I was messing around with my phpMyAdmin, big mistake, and I was adding a password to the root user. When I did that I saw there were two users called root, so I decided to delete the one without a password and my whole phpMyAdmin crashed. I was able to get it to log me in by changing the Listen variable in the httpd.conf, but now it tells me that I have no privileged to do anything.

I did more research and ended up trying to enter the sql code

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
FLUSH PRIVILEGES;

to give the user privileges, but it still did not work. Any help would be appreciated. I tried uninstalling xampp and re-installing it. Still didn't fix the issue.

Thanks

Whoops!!!


http://dev.mysql.com/doc/refman/5.0/...rmissions.html

I tried that and it still didn't work because I already know the password for root, but whenever I try to do anything (create databases or insert SQL commands) it returns the error message "No privileges". Any ideas how to get rid of that. I tried the GRANT command and the FLUSH PRIVILEGES, but it still returns the same errors.

Thanks