phpmyadmin and Access denied

[Kevin Kinsey]

Reinhold Platzoeder wrote:

>Hi
>
>I have a weird problem here
>
>I have installed phpMyAdmin 2.8.0.2 from port
>
>Apache version = apache-2.2.0_7
>PHP version = php5-5.1.2_1
>MySQL version = mysql-server-5.0.19
>
>
>When I go to the index page I get the following error
>
>#1045 - Access denied for user 'root'@'localhost' (using password: NO)
>
>I have configured the config.inc.php file and this is whats in it
>
>  
>
>>cat config.inc.php
>>    
>>
><?php
>/* $FreeBSD: ports/databases/phpmyadmin/files/config.inc.php.sample,v
>1.1 2005/12/05 11:37:27 garga Exp $ *
> * Skeleton configuration file -- this file is empty on a fresh
> * installaton of phpmyadmin.
> * 
> * Copy any settings you want to override from config.defaults.php
> * 
> */
>$cfg['PmaAbsoluteUri'] = 'http://www.violetlan.net/phpmyadmin/';
>
>$cfg['blowfish_secret'] = 'whatever';
>
>$cfg['Servers'][$i]['host']          = 'localhost';
>
>$cfg['Servers'][$i]['auth_type']     = 'cookie';
>
>$cfg['Servers'][$i]['user']          = 'root';
>
>$cfg['Servers'][$i]['password']      = '';
>
>$cfg['Servers'][$i]['connect_type']  = 'socket';
>
>$cfg['Servers'][$i]['socket']        = '/tmp/mysql.sock';
>
>?>
>
>Now the funny thing is that when I change the root password to having no
>password I can get into phpmyadmin
>
>Any ideas as to how I can fix this?
>
>Thanks
>  
>

Run "mysql -u root" at the system's CLI, and you should get a clue.

My guess is that phpadmin is attempting to use "root" and "" as
its account name and pw for a MySQL login, and you have a password
for the root account other than "" (much as it should be).  Hence, when
you make the SQL root password into <NULL>, it works ....  

HTH,

Kevin Kinsey

-- 
Pure drivel tends to drive ordinary drivel off of the TV screen.