Header Ads

How to solve Wampserver error #1045

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

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.

One of the reason that Wamp Server will give this kind of error message is 'you are running another MySQL application in your computer'. (MySQL Workbench) When getting starting to work with the Workbench, most users are set username and password newly. Perhaps user: root but password will be changed by the user. So PHPMYADMIN can't find that password if it is not the same password as you given to your PHPMYADMIN. So, to solve this problem you can edit the 'config.inc.php' file. 
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '3306';
$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'] = USERNAME';
$cfg['Servers'][$i]['password'] = 'PASSWORD';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

No comments

Thank you very much for your ideas!