无法使用pymysq连接到mysql

2024-09-30 18:21:59 发布

您现在位置:Python中文网/ 问答频道 /正文

{I{I试图与下面的mysql连接,但未能与下面的repo脚本连接。在

  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用户配置,我尝试了rootrv

^{pr2}$

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

Tags: tosqlserverondownloadsconnectmysqlsudo