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

[pearl15]

Hello All

I have successfully installed the following

IIS ver 6
php ver 4.4.9
MYSQL ver 5.0.67

when i tested through command line i get no error and i am view the php pages on the browser without any hitch. In the beginning when i was trying to connect to MYSQL through simple php script i was getting an authentication error which i could resolve by using OLD_PASSWORD.

Now during final stages ,
Now when i have installed phpMyAdmin ver 2.0.8.3and have also configured config.inc.php. There is persistent error i am getting which is something like

MYSQL says #1045 - Access denied for user 'root'@'localho st' (using password: NO)

I have tried OLD_PASSWORD technique which won't work. I have almost wasted 2 days on this. Can someone really suggest how to come out of this and make phpMyAdmin work .

[SeeMe]

hi,

you just blank the password. not need key in any password.

[pearl15]

HI
Configuration in my conf.inc.php looks like this.

$cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port']          = '3306';          // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension']     = 'mysql';     // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
                                                    // (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings
                                                    // (this user must have read-only
$cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
                                                    // and "mysql/db" tables).
                                                    // The controluser is also
                                                    // used for all relational
                                                    // features (pmadb)
$cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']          = 'root';      // MySQL user
$cfg['Servers'][$i]['password']      = 'password';          // MySQL password (only needed
                                                    // with 'config' auth_type)

Blanking the password does,nt do any good to me. I still get the same error. User is root and Password is password in my configuration. through command line everything is ok.

pearl

[pearl15]

hi,

you just blank the password. not need key in any password.

It's not helping that way..thanks though for early response..any other way out.

[dlite922]

It's not helping that way..thanks though for early response..any other way out.

can you "ping localhost" from the command line.

If it's Linux, you may not have localhost set as a host name.



Dan