安装mac版的mysql后，启动mysql 报错：
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
解决方法：
参考文档：
http://dev.mysql.com/doc/mysql-macosx-excerpt/5.0/en/macosx-installation.html
After the installation, you can start up MySQL by running the following
commands in a terminal window. You must have administrator privileges
to perform this task.
If you have installed the Startup Item, use this command:
shell> sudo /Library/StartupItems/MySQLCOM/MySQLCOM start (ENTER YOUR PASSWORD, IF NECESSARY) (PRESS CONTROL-D OR ENTER "EXIT" TO EXIT THE SHELL)
If you don't use the Startup Item, enter the following command sequence:
shell> cd /usr/local/mysql shell> sudo ./bin/mysqld_safe (ENTER YOUR PASSWORD, IF NECESSARY) (PRESS CONTROL-Z) shell> bg
(PRESS CONTROL-D OR ENTER "EXIT" TO EXIT THE SHELL)
You should be able to connect to the MySQL server, for example, by
running `/usr/local/mysql/bin/mysql'.
完成上面的命令后，启动mysql成功
reference: http://blog.csdn.net/volcan1987/article/details/8935765
相关推荐
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) 的异常。是用dmg直接安装的以为安装包又出现了奇奇怪怪的错误，正欲卸载该版本时找到了我的问题的关键。 解决...
在安装好了MySQL之后，使用了新的配置文件后，MySQL服务器可以成功启动，但在登陆的时候出现了ERROR 2002 (HY000): Can’t connect to local MySQL server through socket，即无法通过socket连接到mysql服务器，同时...
mysql 支持 socket 和 TCP/IP 连接。那么 mysql.sock 这个文件有什么用呢？本文给大家介绍的非常详细，需要的朋友参考下吧
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) 出现问题原因： 有可能是 my.cnf 配置文件中设置了 [mysqld] 的参数 socket ，而没有设置[client]的参数socket ...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
主要介绍了MySQL错误ERROR 2002 (HY000): Can't connect to local MySQL server through socket,需要的朋友可以参考下
ERROR 2002 (HY000): Can't connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock' (2) 排查过程 1、先查看 /etc/rc.d/init.d/mysqld status 看看mysql是否已经启动. 另外看看是不是权限问题...
?php $link=mysql_connect(‘localhost’,’root’,... 运行后报错 Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ 但在 命令行中能进入mysql [root@localhost local]# mysql -u root -p E
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (2) 2、故障分析 查看mysql实例的状态 [root@localhost scripts]# netstat -ntlp | grep 3306 tcp 0 0 :
前言 最近在数据库的一张表添加两个字段，后来提示什么磁盘空间不足什么什么的，后来数据库就断开连接了，之后就一直连接不上去后来，最后经过思考...ERROR 2002 (HY000): Can't connect to local MySQL server thro
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2) 分析：使用mysql –verbose –help进行分析，才发现原来port和socket对应的值都为0或者为空，也就是默认参数都...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 如果说出现这个一般就是因为MySQL没有起来 [root@localhost ~]# mysql -uroot -p ERROR 1045 (28000):...
服务器：unbuntu16.04，阿里云 ... ...第一阶段：此时以为再重启...ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' 怎么办呢，看看这个啥文件先，然而查到是这个文
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) root@localhost:~# service mysqld restart Shutting down MySQL.. [ OK ] Starting MySQL.