当试图连接到本地主机上3306端口上运行的MySQL数据库时(使用命令行工具mysql),我得到了错误:
错误2002 (HY000):无法通过套接字'/tmp/mysql.sock‘连接到本地MySQL服务器(2)
下面是我使用的命令:
> mysql -h localhost -P 3306
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
指定用户和密码也不起作用:
> mysql -h localhost -
与Galera 25.3.23合作开发RHEL 7.3
盖雷拉以前工作很好。将MySQL服务器端口从3306个更改为13306后,重新启动后,节点报告错误之一:
Slave I/O: error connecting to master 'repuser@<IP>:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on '<IP>' (111 "Connection refused"), In
MySQL [127.0.0.1 ssl] JS> \show
Available reports: query, sessions, thread, threads.
MySQL [127.0.0.1 ssl] JS>
MySQL [127.0.0.1 ssl] JS> \show sessions
reports.sessions: User-defined function threw an exception:
Traceback (most recent call last):
File "init.py", line 2, in sessio