m3chman’s blog

phpmyadmin error #1045

July 4, 2009 · 1 Comment

Just upgraded mysql and phpmyAdmin package on my Debian Lenny 5.0 box and start getting the error:

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

fixed it next way:

in the file: /etc/phpmyadmin/config.inc.php

uncomment next line: //$cfg['Servers'][$i]['auth_type'] = ‘cookie’;

i.e. it must be:
$cfg['Servers'][$i]['auth_type'] = ‘cookie’;

exta info:

Check your config.inc.php file to see what type of authentication is
used. look for $cfg['Servers'][$i]['auth_type'] you have three to choose
from, HTTP, cookie or config.

Because if you use HTTP or cookie authentication you don’t need to put your
user/password in the config.inc.php file. you enter it when you start up
phpMyadmin.

It is not recommended to use config type authentication there:

as noted in the confgi.inc.php of phpmyadmin:

NOTE: do not add security sensitive data to this file (like passwords)
* unless you really know what you’re doing. If you do, any user that can
* run PHP or CGI on your webserver will be able to read them.

Categories: webserver
Tagged: , , , , , , , , ,

1 response so far ↓

  • Ian // October 20, 2009 at 11:48 am | Reply

    Man, you are a LIFE SAVER. My Lenny upgrade seemed to go perfectly smoothly, and then I go to look at the database via phpmyadmin and BAM, Access Denied.

    Thanks a bunch.

    Ian

Leave a Comment