Tuesday, April 17, 2012

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

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

If you were restored the MySQL Database, then set the password which is current restored Database at phpMyAdmin\config.inc file

1)
    $cfg['Servers'][$i]['user'] = 'root';
    $cfg['Servers'][$i]['password'] = 'maheshRestoredDBPassword';

2) You can try Login from command line

C:\xampp\mysql\bin>mysql --user=root --password=maheshRestoredDBPassword