Problems connecting to mysql using phpMyAdmin

[Ryan Schmidt]

On Nov 18, 2010, at 23:40, Ali A Samii wrote:

> I am unable to connect to mysql using phpMyAdmin. I get a #2002 Cannot log in to the MySQL server error.
> 
> I have restarted mysql, reset the password, and rerun the security configuration all from the command line without any problems.
> 
> But when I try to connect from phpMyAdmin, I get the #2002 error.
> 
> I googled it and there are recommendations to change the config.inc.php file and change the following line
> 
> From
> $cfg['Servers'][$i]['host'] = 'localhost';
> to
> $cfg['Servers'][$i]['host'] = '127.0.0.1';
> 
> Which I did, but it made no difference. Makes sense that it made no difference as I have already defined 127.0.0.1 in my /etc/hosts file.

That suggestion is meant to rule out problems relating to the difference between the socket file and a network connection. Connecting to "localhost" uses the socket file. Connecting to "127.0.0.1" opens a network connection.

> Does anyone have a suggestion?

Are you able to connect to mysql using that username and password on the command line?