更新时间:2022-11-29 21:58:02
两个猜测:
运行 mysqladmin 变量 |grep socket
获取套接字所在的位置,然后尝试像这样建立连接:
Run mysqladmin variables | grep socket
to get where the socket is located, and try setting up a connection like so:
pymysql.connect(db='base', user='root', passwd='pwd', unix_socket="/tmp/mysql.sock")
运行 mysqladmin 变量 |grep 端口
并验证端口是 3306.如果不是,您可以像这样手动设置端口:
Run mysqladmin variables | grep port
and verify that the port is 3306. If not, you can set the port manually like so:
pymysql.connect(db='base', user='root', passwd='pwd', host='localhost', port=XXXX)