import pymysql
db = pymysql.connect(host='127.0.0.1', port=3306, user='test', passwd='123456', db='mszj_test', charset='utf8')
cursor = db.cursor()
sql = "select * from mszj_test.order_status"
cursor.execute(sql)
data = cursor.fetchone()
cursor.close()
db.close()
Traceback (most recent call last):
File "C:/Users/Administrator/Documents/WeChat Files/wxid_rm19bnq4bax122/FileStorage/File/2021-07/test001.py", line 3, in
db = pymysql.connect(host='127.0.0.1', port=3306, user='test', passwd='123456', db='mszj_test', charset='utf8')
File "D:\Python\lib\site-packages\pymysql\connections.py", line 353, in init
self.connect()
File "D:\Python\lib\site-packages\pymysql\connections.py", line 633, in connect
self._request_authentication()
File "D:\Python\lib\site-packages\pymysql\connections.py", line 907, in _request_authentication
auth_packet = self._read_packet()
File "D:\Python\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
packet.raise_for_error()
File "D:\Python\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "D:\Python\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1045, "Access denied for user 'test'@'localhost' (using password: YES)")
检查用户名密码 数据库。。。看着代码没啥问题
你的用户名密码不对叭
楼主问题有解决没，碰到相同问题了