WAMP PhpMyAdmin Username And Password.

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:

1	$cfg['Servers'][$i]['AllowNoPassword'] = true;

You can also see what login credentials have been stored:

1 2	$cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = '';