mac mysql 2002_Mac下Mysql启动异常["ERROR 2002 (HY000): Can't connect to local MySQL server through socket...

在mac下使用brew安装mysql，之前没有使用过，今天启动的时候发现启动不了

huijundeMacBook-Pro:bin huijunzhang$ mysql

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

查看mysql的安装位置：

huijundeMacBook-Pro:bin huijunzhang$ which mysql/usr/local/bin/mysql

说明mysql还是安装过的

huijundeMacBook-Pro:bin huijunzhang$ brew info mysql

mysql: stable5.7.13(bottled)

Open source relational database management system

https://dev.mysql.com/doc/refman/5.7/en/

Conflicts with: mariadb, mariadb-connector-c, mysql-cluster, mysql-connector-c, percona-server/usr/local/Cellar/mysql/5.7.13 (13,344 files, 445.0M) *Pouredfrom bottle on 2016-06-30 at 15:05:40From: https://github.com/Homebrew/homebrew-core/blob/master/Formula/mysql.rb

==>Dependencies

Build: cmake ✘

Required: openssl ✔==>Options--with-archive-storage-engine

Compile with the ARCHIVE storage engine enabled--with-blackhole-storage-engine

Compile with the BLACKHOLE storage engine enabled--with-debug

Build with debug support--with-embedded

Build the embedded server--with-local-infile

Build with local infile loading support--with-test

Build with unit tests==>Caveats

We've installed your MySQL database without a root password. To secure it run:

mysql_secure_installation

To connect run:

mysql-uroot

To have launchd start mysql now and restart at login:

brew services start mysql

Or,if you don't want/need a background service you can just run:

mysql.server start

有可能是mysql服务没有启动

huijundeMacBook-Pro:bin huijunzhang$ mysql.server start

Starting MySQL

. SUCCESS!

哈哈，mysql服务启动了，好开心呀！

接下来要试试能否进入mysql了

huijundeMacBook-Pro:bin huijunzhang$ mysql

ERROR1045 (28000): Access denied for user 'huijunzhang'@'localhost' (using password: NO)

这个提示应该很明显了吧，权限问题，mysql下没有huijunzhang这个用户，装过mysql的朋友应该知道，安装mysql默认的用户名是root,端口是3306，别问我为什么知道。。。

那就使用root用户启动：

huijundeMacBook-Pro:bin huijunzhang$ sudo mysql

Password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection idis 4Server version:5.7.13Homebrew

Copyright (c)2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracleis a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type'help;' or '\h' for help. Type '\c'to clear the current input statement.

mysql>mysql>show databases->;+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

+--------------------+

4 rows in set (0.01 sec)

哈哈，问题解决了，好开心呀！

总结：出现“ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)”的根本原因就是mysql服务没有启动,下面总结下mysql在mac下的几个常用的命令吧！

$ mysql.server start

$ mysql.server restart

$ mysql.server stop

$ mysql.server status

$mysql -u root -p