This is something that caught me off-guard a while back, so I figured that I would write a quick post about it. Hopefully, I can save you some time and confusion!
A couple of years ago, I installed WAMP via a handy installer that did all of the work for me. This installer automatically created Apache, MySQL, PHP and phpMyAdmin on my Windows PC. i.e. I didn’t have to mess around with configuration files or Apache modules and I didn’t have to manually install phpMyAdmin!
As you probably already know, phpMyAdmin is a web-based administration tool for MySQL. It gives you a GUI interface that allows you to create MySQL databases and table structures. When you automatically install WAMP on a Windows PC, phpMyAdmin is usually located at http://localhost/phpmyadmin
Unfortunately for me, I could not login to phpMyAdmin as I did not know what the MySQL username and password was! During the installation process, I was not asked to create a user account. In fact, the only thing that I was asked was which installation path I wanted to use.
Default phpMyAdmin username and password.
If you’re having trouble logging into a fresh install of phpMyAdmin, then simply use the following username and password:
- user: root
- password: *blank*
The above login credentials belong to the default MySQL user account that gets created during a new install. Note that you should leave the password field completely blank. Do not actually type in *blank*.
If those details do not work, then you should open up the config.inc.php in your phpMyAdmin folder. Firstly make sure that AllowNoPassword is set to true:
$cfg['Servers'][$i]['AllowNoPassword'] = true;
You can also see what login credentials have been stored:
$cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = '';
Hopefully, this article saved you some time and confusion!