修改my.cnf后本地MySQL无法连接,多种排查无效求助
MySQL本地连接故障排查求助
原本正常的本地开发环境,因调整SQL配置编辑my.cnf文件后,所有方式均无法连接MySQL。已尝试网上能找到的几乎所有方法,现将近两周排查的操作整理如下:
- 通过终端卸载并删除MySQL文件
- 重装MySQL后尝试通过终端连接失败
执行终端命令:mysql -u root
返回套接字错误:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) - 通过DBngin连接服务
所有服务(Homebrew服务:php、mysql、httpd)启动后显示绿灯,看似正常运行 - 尝试通过TablePlus连接MySQL
此前正常使用的配置(无密码):Host: 127.0.0.1Port: 3306User: root
返回错误:Can't connect to MySQL server on '127.0.0.1' (61) - 安装MySQL Workbench/Server后仍无法连接
返回错误:SQLSTATE[HY000] [2002] Connection refused - 在Chrome/Safari/Firefox中访问localhost:3306均返回错误:
SQLSTATE[HY000] [2002] Connection refused - 检查MySQL运行状态
执行终端命令:ps aux |grep mysql
返回结果:natashya 74640 0.0 0.0 34132100 908 s002 S+ 1:40pm 0:00.00 grep mysql
尝试终止进程:kill 74640
返回:kill: kill 74640 failed: no such process
执行:brew services restart mysql
返回:==> Successfully stoppedmysql(label: homebrew.mxcl.mysql) ==> Successfully startedmysql(label: homebrew.mxcl.mysql)
当前使用的my.cnf文件内容:
# Default Homebrew MySQL server config # Only allow connections from localhost [mysqld] bind-address = 127.0.0.1 mysqlx-bind-address = 127.0.0.1 port = 3306 mysqlx-port = 33060 socket = /var/lib/mysql/mysql.sock datadir = /usr/local/mysql tmpdir = /tmp mysqlx=OFF [client] port = 3306 socket = /var/lib/mysql/mysql.sock
感谢Bill Karwin的帮助,但我仍无法访问localhost:9000,报错:SQLSTATE[HY000] [2002] Connection refused,恳请解决。
内容的提问来源于stack exchange,提问作者NatashyaVee
相关产品推荐
相关产品推荐

