I am using MAC OS Sierra . and trying to access mysql but getting error like
UserXs-MacBook-Pro:~ Ayaz$ mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
UserXs-MacBook-Pro:~ Ayaz$
Asked
Active
Viewed 5,565 times
1
Ayaz Ahmad Tarar
- 534
- 8
- 24
-
Can you check whether your MySQL instance is running or not firstly? – N00b Pr0grammer Dec 05 '16 at 14:54
-
I have check its running via XAMP server – Ayaz Ahmad Tarar Dec 05 '16 at 15:06
-
Can you try `mysql -u root -h 127.0.0.1` instead, /tmp/mysql.sock is used when connecting via localhost socket, whereas 127.0.0.1 will not use mysql.sock – HelloSpeakman Dec 05 '16 at 15:07
-
`UserXs-MacBook-Pro:~ Ayaz$ mysql -u root -h 127.0.0.1 ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61) UserXs-MacBook-Pro:~ Ayaz$ ` – Ayaz Ahmad Tarar Dec 05 '16 at 15:09
-
Hi Ayaz, this will mean that you don't have a current instance of MySQL running to connect to. – HelloSpeakman Dec 05 '16 at 15:15
-
I have mysql installed perfectly `UserXs-MacBook-Pro:~ Ayaz$ mysql --version mysql Ver 14.14 Distrib 5.7.16, for osx10.12 (x86_64) using EditLine wrapper` – Ayaz Ahmad Tarar Dec 05 '16 at 15:16
-
MySQL is installed, but it is not running, try the following command `sudo /usr/local/mysql/support-files/mysql.server start` – HelloSpeakman Dec 05 '16 at 16:52
-
`sh-3.2# sudo /usr/local/mysql/support-files/mysql.server start` `sudo: /usr/local/mysql/support-files/mysql.server: command not found` – Ayaz Ahmad Tarar Dec 05 '16 at 17:30
-
you should check this answer. https://stackoverflow.com/questions/16325607/cant-connect-to-local-mysql-server-through-socket-tmp-mysql-sock/30359831#30359831 – H.seongjun Aug 26 '23 at 19:47
2 Answers
2
If you have your MySQL UP and running, you could try the following step to get your issue sorted out!
This worked for me and hope works for you too!
sudo /usr/local/mysql/support-files/mysql.server start
This is an interesting question on SO which is on a similar discussion, hope that this helps!!!
Community
- 1
- 1
N00b Pr0grammer
- 4,503
- 5
- 32
- 46
-
i tried but got error like `sudo: /usr/local/mysql/support-files/mysql.server: command not found` – Ayaz Ahmad Tarar Dec 05 '16 at 15:05
-
Did you check the question that I pointed to on the same topic? – N00b Pr0grammer Dec 06 '16 at 01:18
0
Check this. I wasn't running MySQL Server. Run server first.
$ mysql.server start
$ mysql -h localhost -u root -p your_password
if you install at Mac os. There is no password
$ mysql -h localhost -u root -p
H.seongjun
- 41
- 6