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