PhpMyAdmin Password

[Krissinn]

So, its like this.

 

I change my password in config.inc.php like I have read on Google. Put my password between these "" two. Like this:

 

 

/* Servers configuration */

$i = 0;

 

/* Server: localhost [1] */

$i++;

$cfg['Servers'][$i]['verbose'] = 'localhost';

$cfg['Servers'][$i]['host'] = 'localhost';

$cfg['Servers'][$i]['port'] = '';

$cfg['Servers'][$i]['socket'] = '';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['extension'] = 'mysqli';

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

$cfg['Servers'][$i]['user'] = 'root';

$cfg['Servers'][$i]['password'] = 'lykilord'; <--

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

 

/* End of servers configuration */

 

$cfg['DefaultLang'] = 'en-utf-8';

$cfg['ServerDefault'] = 1;

$cfg['UploadDir'] = '';

$cfg['SaveDir'] = '';

 

 

/* rajk - for blobstreaming */

$cfg['Servers'][$i]['bs_garbage_threshold'] = 50;

$cfg['Servers'][$i]['bs_repository_threshold'] = '32M';

$cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600;

$cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';

 

As you can see I have chosen my password wisely, but still it does not work. When I save the file I get this error in PhpMyAdmin

 

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

 

and bellow that

 

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

 

I can't figure this out, can someone help me?

 

Sorry if this is not well spelled or something, I am from Iceland.

 

 

[fugix]

what version of mysql are you running?

[Krissinn]

what version of mysql are you running?

Well I am running Wamp 2.1a thats all I know about that. And I am using Windows 7 if that says anything.

[fugix]

Have you restarted Wamp after changing your password?

[fugix]

after you restart Wamp, if you are still receiving this error..perhaps this link will help

here

[ignace]

Well I am running Wamp 2.1a thats all I know about that. And I am using Windows 7 if that says anything.

 

I am running the same config. By default every account has no password. To set a password for an account you must do it through MySQL. Download and install HeidiSQL http://www.heidisql.com/

 

After installation, run it! You'll get the session manager, click New and give it a name (localhost for example) fill in 127.0.0.1 for the Hostname and root for the User, press Open. Click Tools, User Manager. In this dialog you can effectively manage the users on your MySQL install. Add a new user, give it a password and the necessary privileges and press Save. Enter the new username and password in the PMA config.