ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'

mysql macos
shrewdbeans picture shrewdbeans · Mar 16, 2013 · Viewed 323k times · Source

I installed MySQL on Mac OS X Mountain Lion with homebrew install mysql, but when I tried mysql -u root I got the following error:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

What does this error mean? How can I fix it?

Answer

shammerw0w picture shammerw0w · Jan 29, 2014

It's probably because MySQL is installed but not yet running.

To verify that it's running, open up Activity Monitor and under "All Processes", search and verify you see the process "mysqld".

You can start it by installing "MySQL.prefPane".

Here is the complete tutorial which helped me: http://obscuredclarity.blogspot.in/2009/08/install-mysql-on-mac-os-x.html

Related questions

Setting the MySQL root user password on OS X

I just installed MySQL on Mac OS X. The next step was setting the root user password, so I did this next: Launch the terminal app to access the Unix command line. Under the Unix prompt I executed these commands: $ …

Read More
How to stop mysqld

To find out the start command for mysqld (using a mac) I can do: ps aux|grep mysql I get the following output, which allows me to start mysql server. /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=... …

Read More
start MySQL server from command line on Mac OS Lion

I installed mySQL for my Mac. Beside starting the SQL server with mySQL.prefPane tool installed in System Preference, I want to know the instruction to start from command-line. I do as follow: After su root I start the mySQL …

Read More