Mysql5.5使用旧密码报错错误,导致整个面板不能正常使用
我的项目必须用到mysql旧密码加密,因此配置文件添加了old_passwords=1生效后,虽然可以使用navicat mysql登录数据库,但似乎无法保存修改的数据,整个宝塔面板异常,基本上跟数据库有关的功能全部不能用,提示如下错误
AttributeError: module 'pymysql._auth' has no attribute 'scramble_old_password'
该如何解决?
根据提示尝试修复面板仍然无法解决这个问题,也无法删除mysql,经过反复折腾卸载了数据库重新安装,但仍然存在这个问题 出错了，面板运行时发生错误！
AttributeError: module 'pymysql._auth' has no attribute 'scramble_old_password'
REQUEST_DATE: 2023-06-18 21:52:43
PAN_VERSION: 7.9.10
OS_VERSION: CentOS7.9.2009 x86_64(Py3.7.9)
REMOTE_ADDR: 192.168.200.1
REQUEST_URI: POST /database?action=SyncGetDatabases
REQUEST_FORM: {＇sid＇: ＇0＇}
USER_AGENT: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36
Traceback (most recent call last):
File "/www/server/panel/BTPanel/__init__.py", line 2006, in publicObject
res = run_obj.run(toObject, defs, get)
File "/www/server/panel/BTPanel/__init__.py", line 1953, in run
result = getattr(toObject, get.action)(get)
File "class/database.py", line 1064, in SyncGetDatabases
data = mysql_obj.query("show databases")
File "class/panelMysql.py", line 116, in query
if not self.__Conn(): return self.__DB_ERR
File "class/panelMysql.py", line 60, in __Conn
self.__DB_CONN = MySQLdb.connect(host = self.__DB_HOST,user = self.__DB_USER,passwd = self.__DB_PASS,port = self.__DB_PORT,charset="utf8",connect_timeout=1,unix_socket=socket)
File "/www/server/panel/pyenv/lib/python3.7/site-packages/pymysql/connections.py", line 353, in __init__
File "/www/server/panel/pyenv/lib/python3.7/site-packages/pymysql/connections.py", line 633, in connect
self._next_seq_id = 0
File "/www/server/panel/pyenv/lib/python3.7/site-packages/pymysql/connections.py", line 921, in _request_authentication
if (
File "/www/server/panel/pyenv/lib/python3.7/site-packages/pymysql/connections.py", line 966, in _process_auth
data = (
AttributeError: module 'pymysql._auth' has no attribute 'scramble_old_password'
页:
[1]