Traceback (most recent call last):
File "/root/onearrange/webase-deploy/comm/mysql.py", line 144, in checkMgrDbAuthorized
conn = mdb.connect(host=mysql_ip, port=mysql_port, user=mysql_user, passwd=mysql_password)
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 352, in __init__
self.connect()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 636, in connect
self._request_authentication()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 911, in _request_authentication
auth_packet = self._read_packet()
File "/usr/local/lib/python3.10/dist-packages/pymysql/connections.py", line 729, in _read_packet
packet.raise_for_error()
File "/usr/local/lib/python3.10/dist-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/usr/local/lib/python3.10/dist-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
报错:
更改mysql用户密码
格式:ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password';
by 'your_password' 输入你的密码
alter user 'root'@'localhost' identified with mysql_native_password by '123456'