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
