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.
1 response so far ↓
Ian // October 20, 2009 at 11:48 am |
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