Problems connecting to mysql using phpMyAdmin

[Ali A Samii]

Hi:

I am assuming, because I'm not sure how to check this) that the mysql server is NOT configured to use the "old" password algorithm. This is a fresh and clean install, using the MAMP wiki on trac.macports.com and a fresh install of all the various components and variants.

Using the same basic installation process (but with my documents root in the default /opt/local/apache2/..... hierarchy on another machine, I had no problems. The only difference here is the doc root.

On 19 Nov, 2010, at 08:44 , Ryan Schmidt wrote:

> 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?
>>> 
>> 
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2659 bytes
Desc: not available
URL: <http://lists.macosforge.org/pipermail/macports-users/attachments/20101119/a5aa502c/attachment.bin>