错误代码:
code: 'ER_NOT_SUPPORTED_AUTH_MODE',
errno: 1251,
sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client',
sqlState: '08004',
fatal: true
首先找到你的数据库目录,win键搜索服务找到你的MySQL鼠标右键属性找到你的mysql路径
复制路径的文件夹bin目录路径,然后win+R打开命令行输入cmd打开命令窗口,cd +你复制的bin目录切换到你mysql的bin目录下然后登录MySQL,登录命令:mysql -r root -u,root是你的数据库登录名字,然后输入你的密码。
这个前缀就是已经登录成功了,然后输入重置密码命令:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';