Apache Friends Support Forum

Where is the phpMyAdmin password saved?

OK - a clarification -

phpMyAdmin is a shell for MySQL - ergo - for user(s) [created] and 'root' the passwords are saved in the database 'mysql' in the table 'user'.

PhpMyAdmin also has a 'special user', the PMA Control User. (its used by the phpMyAdmin program itself). Its username is 'pma' in the same table.

Summary: There really isn't "a" phpMyAdmin password. XAMMP comes out of the box with a 'root' MySQL user with no password (as do all fresh mySQL installs). The password you want for phpMyAdmin is probably the password for 'root'. If its a new install that is a null (none). If you set a password for 'root' but cannot recover it/remember what it was, you can use the 'resetroot.bat' in \xampp\mysql'.

Good Luck

JonB wrote:OK - a clarification -

phpMyAdmin is a shell for MySQL - ergo - for user(s) [created] and 'root' the passwords are saved in the database 'mysql' in the table 'user'.

PhpMyAdmin also has a 'special user', the PMA Control User. (its used by the phpMyAdmin program itself). Its username is 'pma' in the same table.

Summary: There really isn't "a" phpMyAdmin password. XAMMP comes out of the box with a 'root' MySQL user with no password (as do all fresh mySQL installs). The password you want for phpMyAdmin is probably the password for 'root'. If its a new install that is a null (none). If you set a password for 'root' but cannot recover it/remember what it was, you can use the 'resetroot.bat' in \xampp\mysql'.

Good Luck

Thanks for the explanation. So the password to root is stored in MySQL database?

yes it is

Altrea wrote:yes it is

Oh okay. Thanks for the help.