Create a root password for PHPMyAdmin

Open phpMyAdmin and select the SQL tab. Then type this command:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('your_root_password');

Also change to this line in config.inc.php:

$cfg['Servers'][$i]['auth_type'] = 'cookie';

To make phpMyAdmin prompts for your MySQL username and password.

To create root password in PHPMyAdmin in UI easy way, you can follow simple steps below:

• Access phpMyAdmin with root account (no password) -> User accounts.

Click on root > Edit privileges

Then click on Change password

Enter your desired password -> Go

Logout and log-in again with new password

Well, I believe that I've solved the password configuration 'issue' - WampServer 2.2 - Windows 7.

The three steps that I did:

1. In the MySQL console set a new password. To make that: mysqladmin -u root password 'your_password'

2. In phpMyAdmin click in users and set the same password to the user root.

3. Finally, set your new password in the config.inc.php. Don't change anything else in this file.

This worked for me. Good luck!

Daniel