Tuesday, July 11, 2006

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

When installing phpMyAdmin the most common error is not being able to connect to the database after installation.



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

Here is the solution:
Make sure your config file in the phpMyAdmin directory is named "config.inc.php"!

In the installation instuctions it says to copy config.default.php into the phpMyAdmin directory and then customize it (usually the only change needed is to change the 'auth_type' is changed from 'config' to 'http'). Make sure to rename config.default.php to config.inc.php.

2 comments:

Anonymous said...

hello, i use windows and i have config.inc in phpmyadmin. Then do i most rename config.inc to config.inc.php ? and no more? I'm new in mysql please be charm.

And write me the answer in ms_castros2@hotmail.com please ... and thanks a lot.

Anonymous said...

Great answer to a simple but annoying problem. Thanks!