#1045 – Access denied for user ‘root’@’localhost’ (using password: NO)

#1045 – Access denied for user ‘root’@’localhost’ (using password: NO)

Hi friends, recently i have installed MySQL on my laptop and all my website hosted on wamp are not working with error: Error establishing a database connection. I tried to connect phpmyadmin but result with another error: #1045 – Access denied for user ‘root’@’localhost’ (using password: NO) or (1045-access-denied-for-user-root-localhost-using-password-no). I looked on error and got to know that this error comes due to a password set by me on MySQL and on phpmyadmin config file ‘AllowNoPassword’ is set to true. To overcome this issue you have to modify your phpmyadmin config file.

In previous post we have learnt MySQL to SQL Server Data Migration Through SSIS, ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application, How to Install MySQL in Windows 7.

File Location: C:\wamp\apps\phpmyadmin3.5.1

1. Then open config.inc.php in your text editor.
2. Now find $cfg[‘Servers’][$i][‘password’] = ”; and change it with $cfg[‘Servers’][$i][‘password’] = ‘root’; (put root password here).
3. Now find $cfg[‘Servers’][$i][‘AllowNoPassword’] = true; and replace it by $cfg[‘Servers’][$i][‘AllowNoPassword’] = false;.
4. Save file. Now restart the wampserver. To do this left-click the wamp icon in the windows taskbar (Notification one), a box will pop up then just click on Restart all Services.

Code:

$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'] = 'root';
$cfg['Servers'][$i]['AllowNoPassword'] = false;