Ok guys, I screwed up my XAMPP install by accidentally deleting the pma user from the mysql.users table, so phpMyAdmin doesn't work now. Anyone that can give me the INSERT query to rebuild this user so phpMyAdmin will work again? I would do it myself but I don't know what the proper settings for it should be.
Assuming you want full privileges: -- mysql.user table INSERT INTO `user` VALUES ('localhost', 'pma', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0); Code (markup):
Argh, I inserted it back into the database, but still get this error when I try to log in to phpMyAdmin. Why is it not working when I put the damned password back. Is it possible that pma had a default password, which is what phpMyAdmin is trying to login with? #1045 - Access denied for user 'pma'@'localhost' (using password: NO)
You can check the config.inc.php in the phpMyAdmin directory to check but the error message mentions a password is not being used.
what is pma stands for root ? if not then you can able to login with root take your full database backup and reinstall xampp after that import that backup it's Done. simple
Yea I realize a password is not being used. I'm asking for someone who has experience with XAMPP: if the PMA user needs a default password that phpMyAdmin uses to login, what is it?
I've also tried using XAMPP's IRC channel, but it's so dead I got no response. I just need to know what default password XAMPP uses for PMA