python3在连接数据库时:
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on '127.0.0.1' ([Errno 2] No such file or directory)")
在所有信息正确的情况下可能是my.conf
下开启了skip-networking
或绑定了IP
skip-networking
bind-address = 127.0.0.1
若要开启skip-networking
的情况下使用,则用unix_socket来连接
pymysql.connect(host='127.0.0.1',
unix_socket='/xxx/mysqld.sock',
user='root',
passwd='root',
db='test',
charset='utf8')