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