mysql 启动报错Can't connect to local MySQL server through socket '/data/mysql/mysql/mysql.sock'(111)

1:首先mysql本地连接报错:

  Can't connect to local MySQL server through socket '/data/mysql/mysql/mysql.sock'(111)

  解决:

    1:删除 文件:/data/mysql/mysql/mysql.sock

  此时又会报错:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

  进入到目录:/data/mysql2/bin/

    使用命令:mysqld start

    此时报错:[ERROR] Too many arguments (first extra is 'start')

    于是将命令修改:mysqld --user=mysql

感谢:

  https://www.cnblogs.com/invban/p/5824796.html

  https://blog.csdn.net/u010416101/article/details/80490536

2:19年7月4日,mysql不是自己安装的,也不晓得是怎么安装的.在启动时依然报这个错误,按照前面的方法还是解决不了.

然后我又使用如下命令,启动依然报错

./mysqld --defaults-file=/data/mysql/mysql01/my.cnf --basedir=/data/mysql/mysql01 --datadir=/data/mysql/mysql01/data  --user=zabbix

  

原文地址:https://www.cnblogs.com/xiangyuqi/p/10221129.html