pymysql与skip-networking

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')