python - Python MySQLdb错误

当我运行我的脚本时，它无法连接到mysql数据库，我无法从godaddy找到我的主机名，我只尝试了mysq.mydomain.com和mydomain.com。数据库的登录详细信息正确。

Traceback (most recent call last):
  File "mysql.py", line 6, in <module>
    conn = MySQLdb.connect(host="?",user="?",passwd="?",db="?")
  File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'official_autotes'@'104.156.228.189' (using password: YES)")


------------------

我的代码

from threading import Thread
import urllib
import re
import MySQLdb

conn = MySQLdb.connect(host="?",user="?",passwd="?",db="?")

query = "INSERT INTO tutorial (symbol) values ('AAPL')"
x = conn.cursor()
x.execute(query)
row = x.fetchal()

最佳答案

试图使用Python代码访问MySQL表的用户和ip的特权。要执行相同的操作，请在mysql shell中执行以下命令。

GRANT <privileges> ON database.* TO 'user'@'ip' IDENTIFIED BY 'password';
flush privileges;

关于python - Python MySQLdb错误，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/33096031/