It has recently been brought to my attention that there are limited resources instructing as to how one can manually set a password in the wamp server’s phpMyAdmin. In fact, I was unable to find a single resource instructing one how to properly put the often needed password into the wamp server’s phpMyAdmin. Why would this matter?

Often MySQL is installed and set with a password. The wamp server’s phpMyAdmin is set to not require a password by default. When one tries to run phpMyAdmin they receive the following error:

MySQL said:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

Instructions to set a password to the Wamp Server’s phpMyAdmin:

Navigate to the phpMyAdmin folder which contains the config.inc.php file:

• ‘Computer’
• Double click Local Disk usually (C:) drive
• Open the ‘wamp’ folder (sometimes this is located within the ‘Program Files’ folder)
• Open the ‘apps’ folder
• Open the phpmyadmin folder
• Open the ‘config.inc.php’ file with your favorite text editor ( notepad ++ )
• Locate the following part in the config.inc.php file

$cfg['Servers'][$i]['user'] = ‘root’;
$cfg['Servers'][$i]['password'] = ”;
$cfg['Servers'][$i]['AllowNoPassword'] = true;

• If you use a user other than ‘root’ for your MySQL feel free to change it, but make sure you are using something else
• Place your MySQL password in between the ” like this:

$cfg['Servers'][$i]['password'] = ‘yourpassword’;

• Change the $cfg['Servers'][$i]['AllowNoPassword'] = true;  to false like this:

$cfg['Servers'][$i]['AllowNoPassword'] = false;

• Save the file
• Open the wamp server and click ‘phpMyAdmin’ (if wamp was running refresh it and phpMyAdmin)