首页 文章

Python MySQLdb连接错误

提问于
浏览 次
2

我想将我的数据从json传输到mysql，因为我安装了python库MySQLdb . 它导入成功但连接时出错

>>> import MySQLdb
>>> db=MySQLdb.connect(passwd="king123",db="thangs")

Traceback (most recent call last):
  File "<pyshell#1>", line 1, in <module>
    db=MySQLdb.connect(passwd="king123",db="thangs")
  File "C:\Python27\lib\site-packages\MySQLdb\__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 187, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

>>> import _mysql
>>> db=_mysql.connect()

Traceback (most recent call last):
  File "<pyshell#3>", line 1, in <module>
    db=_mysql.connect()
OperationalError: (2003, "Can't connect to MySQL server on 'localhost' (10061)")

db = MySQLdb.connect（passwd =“rat123”，db =“thangs”，host =“localhost”，port = 1028，user =“mroot”）

Traceback (most recent call last):
  File "<pyshell#41>", line 1, in <module>
db=MySQLdb.connect(passwd="king123",db="thangs",host="localhost",port=1028,user="munieb")


File "C:\Python27\lib\site-packages\MySQLdb\__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 187, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (2013, "Lost connection to MySQL server at 'waiting for initial communication packet', system error: 2")
python mysql-python

2 回答

  • 1

    您需要指定server and point .

    db=MySQLdb.connect(passwd="king123",db="thangs",host="hostname",port=3251,user="user")
    回复于
  • 1

    我有同样的问题，对我来说，问题是与ip地址，mysql听取端口3305 . 通过 netstat -aon 我看到：

    Proto  Local Address          Foreign Address        State           PID
...
TCP    0.0.0.0:3306            0.0.0.0:0              LISTENING       884
...

    所以我在 my.ini 配置文件中取消注释下面的行：

    #bind-address="127.0.0.1"

    然后重启mysql，问题就没了！

    回复于

相关问题