Python MySQLdb 错误

Question

当我运行我的脚本时，它不会连接到 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()

Answer 1

向尝试使用 Python 代码访问 MySQL 表的用户和 ip 授予权限。为此，请在 mysql shell 中执行以下命令。

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