Monday 18 February 2013

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


After installed WAMPserver "package" on default doesn't have password set for MySQL and for example everyone can log to database.
When you start first time phpmyadmin you can notice red table with contents ...has default user "root" with no password... so you need set password for database and after this I occurred problem to log to phpmyadmin.

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

To solve this annoying problem you have to edit one option in file : 

%/wamp/app/phpmyadmin***/config.inc.php

find line (see below) and replace 'config' to 'cookie' and that's all, now you can log and testing phpmyadmin with your credentials.


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

Should be : 

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

No comments: