phpMyAdmin password? [Solved]

Problems with the Windows version of XAMPP, questions, comments, and anything related.

phpMyAdmin password? [Solved]

Postby dalawh » 29. June 2012 19:48

Where is the phpMyAdmin password saved?
dalawh
 
Posts: 4
Joined: 07. June 2012 16:00
Operating System: Windows 7 64-bit

Re: phpMyAdmin password?

Postby JonB » 29. June 2012 20:18

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
8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: phpMyAdmin password?

Postby dalawh » 29. June 2012 20:32

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
8)

Thanks for the explanation. So the password to root is stored in MySQL database?
dalawh
 
Posts: 4
Joined: 07. June 2012 16:00
Operating System: Windows 7 64-bit

Re: phpMyAdmin password?

Postby Altrea » 29. June 2012 21:39

yes it is
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8297
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: phpMyAdmin password?

Postby dalawh » 29. June 2012 22:05

Altrea wrote:yes it is

Oh okay. Thanks for the help.
dalawh
 
Posts: 4
Joined: 07. June 2012 16:00
Operating System: Windows 7 64-bit


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 72 guests