Problems connecting to mysql using phpMyAdmin

[Ryan Schmidt]

Yes, your answer did get through, I just didn't have a response yet.

Only reason I can think of why you could connect to the MySQL server on the command line but not from PHP:

Is your MySQL server (or this root account, anyway) configured to use the "old" (MySQL < 4.1) password algorithm? If so that doesn't work with mysqlnd (which is what php5-mysql now uses by default) so you should either (ideally) upgrade to the "new" algorithm or if you must keep the old algorithm, then install php5-mysql with the +mysql5 variant.


On Nov 19, 2010, at 01:40, Ali A Samii wrote:

> Just incase it didn't get through, my answer to your question is yes, I can connect to mysql on the command line using that username and password.
> 
> On 19 Nov, 2010, at 06:45 , Ryan Schmidt wrote:
> 
>> 
>> 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?
>> 
>