python pymysql连接数据库pymysql.err.OperationalError 1044
16lz
2021-01-22
错误详细过程
>>> import pymysql
>>> conn = pymysql.connect(host='192.168.88.95',user='analyze',password='analyze*&g0$X!$S',db='analyze',port=52541, charset='utf8')Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/lib64/python2.7/site-packages/pymysql/__init__.py", line 90, in Connect
return Connection(*args, **kwargs)
File "/usr/lib64/python2.7/site-packages/pymysql/connections.py", line 704, in __init__
self.connect()
File "/usr/lib64/python2.7/site-packages/pymysql/connections.py", line 974, in connect
self._request_authentication()
File "/usr/lib64/python2.7/site-packages/pymysql/connections.py", line 1203, in _request_authentication
auth_packet = self._read_packet()
File "/usr/lib64/python2.7/site-packages/pymysql/connections.py", line 1059, in _read_packet
packet.check_error()
File "/usr/lib64/python2.7/site-packages/pymysql/connections.py", line 384, in check_error
err.raise_mysql_exception(self._data)
File "/usr/lib64/python2.7/site-packages/pymysql/err.py", line 109, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1044, u"Access denied for user 'analyze'@'192.168.88.%' to database 'analyze'")
>>>
错误原因
大多数pymysql.err.OperationalError报错的错误码是1045，所以查出来的解决方法多是需要给IP或者账号赋权，被误导了好长时间；最终原因是连接时指定的DB库名错误，开发过程中的习惯是用户名和库名一致，这次DBA给的账号不一致，导致习惯性黏贴出错。
更多相关文章
- MySQL查询中的变量会导致错误
- mysql编译安装后各种常见错误集锦
- org.json Android系统错误。JSONException:在字符0处输入结束
- Navicat连接mysql8出现1251错误
- MYSQL错误代码和消息
- mySQL错误: The used table type doesn't support FULLTEXT inde
- MySQL 主从同步Out of Memory 错误分析
- PHP解析错误:语法错误，意外的T_VARIABLE
- PHP OOP和MySQLi连接=致命错误:调用未定义的方法sqmyli::arrayQu