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? >> > _______________________________________________ macports-users mailing list [email protected] http://lists.macosforge.org/mailman/listinfo.cgi/macports-users
