我想要使用Python來連接MySQL數(shù)據(jù)庫,但是報了如下錯誤
File "/usr/local/lib/python3.5/dist-packages/pymysql/__init__.py", line 94, in Connect
return Connection(*args, **kwargs)
File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 325, in __init__
self.connect()
File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 599, in connect
self._request_authentication()
File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 861, in _request_authentication
auth_packet = self._read_packet()
File "/usr/local/lib/python3.5/dist-packages/pymysql/connections.py", line 684, in _read_packet
packet.check_error()
File "/usr/local/lib/python3.5/dist-packages/pymysql/protocol.py", line 220, in check_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.5/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.InternalError: (1049, "Unknown database 'expert'")
百度結(jié)果均告知為未創(chuàng)建相應(yīng)的數(shù)據(jù)庫導(dǎo)致本錯誤,但是我已經(jīng)創(chuàng)建了expert數(shù)據(jù)庫,但仍然提示數(shù)據(jù)庫不存在。此外,本服務(wù)器下的數(shù)據(jù)庫均能正常連接。
這是我的數(shù)據(jù)庫連接代碼:
config = {
'host': cf.get("mySql", "host"),
'port': int(cf.get("mySql", "port")),
'user': cf.get("mySql", "user"),
'password': cf.get("mySql", "password"),
'db': cf.get("mySql", "db"),
'charset': cf.get("mySql", "charset")
}
table_to_save = cf.get("mySql", "save_table")
try:
con = pymysql.connect(**config)
except Exception:
con = Exception
log_info = "Connection to MySQL has been rejected"
print(log_info)
os._exit(0)
配置文件為:
[mySql]
host=127.0.0.1
port=3306
user=root
password=123456
db=expert
charset=utf8
有大佬可以幫忙解決一下嗎?
添加回答
舉報
0/150
提交
取消