Mysql Error: #1045

After installed the XAMPP and mySQL, when you typed

http://localhost/phpmyadmin

in your web browse to get into the phpmyadmin, it shows a error like this:

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

At this point you have to edit the config.inc.php file on line 21  $cfg[‘Servers’][$i][‘password’]             = ”; to $cfg[‘Servers’][$i][‘password’]             = ‘yourpassword’;

config.inc.php file will found in xampplitephpMyAdmin

now restart your XAMPP and refresh your web browser.

if you still got the same error then just try this

http://localhost/phpmyadmin/?username=xxxx&password=yyyy

Note: type your mysql username in xxxx andpassword in yyyy

yow will get logged in.

Permanent link to this article: https://blog.openshell.in/2011/01/mysql-error-1045/

Leave a Reply

Your email address will not be published.