redconservatory redconservatory - 4 months ago 23
MySQL Question

mysql password works in Terminal, but not in phpMyAdmin?

I can log in to mysql through Terminal using

mysql -u root -p

I'm prompted with:

Enter password:

When I enter the password I get:

Welcome to the MySQL monitor....

However, when I try to user the same username/password combination into phpMyAdmin I get the rror:

#2002 Cannot log in to the MySQL server

Note: I am using Snow Leopard


Because I am in Snow Leopard, I had to do the following.

Open Terminal

cd /etc/
sudo nano php.ini // or php.ini.default
Password: (enter my password)

And replace var/mysql/mysql.sock with the following:

mysql.default_socket = /tmp/mysql.sock
mysqli.default_socket = /tmp/mysql.sock

Then in Terminal

sudo apachectl restart