无法使用pymysql连接到mysql

siotufzp  于 2021-06-20  发布在  Mysql
关注(0)|答案(0)|浏览(290)

我正试图通过在他们的repo上共享的以下示例脚本从pymysql连接到mysql,但它一直失败,并显示以下消息。

File "/Users/svenkatesh/Library/Python/2.7/lib/python/site-packages/pymysql/connections.py", line 818, in _connect
    2003, "Can't connect to MySQL server on %r (%s)" % (self.host, e))
pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (255)")

这是mysql用户配置,我尝试了root和rv,

mysql> select user, host, plugin from user;
+------------------+-----------+-----------------------+
| user             | host      | plugin                |
+------------------+-----------+-----------------------+
| mysql.infoschema | localhost | mysql_native_password |
| mysql.session    | localhost | mysql_native_password |
| mysql.sys        | localhost | mysql_native_password |
| root             | localhost | caching_sha2_password |
| rv               | localhost | mysql_native_password |

mysql服务似乎在所需的端口上也运行良好。

C02WK0DQHV2J:Downloads svenkatesh$ sudo lsof -nPi -sTCP:LISTEN | grep sql
Password:
mysqld    15390         _mysql   19u  IPv6 0xf35d852c37f052c1      0t0  TCP *:3306 (LISTEN)
mysqld    15390         _mysql   22u  IPv6 0xf35d852c3792ce41      0t0  TCP *:33060 (LISTEN)

C02WK0DQHV2J:Downloads svenkatesh$ sudo netstat -an | grep -i sql
f35d852c413e4b61 stream      0      0 f35d852c463e3ca9                0                0                0 /tmp/mysqlx.sock
f35d852c413e65f1 stream      0      0 f35d852c44094009                0                0                0 /tmp/mysql.sock

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题