时间:2021-07-01 10:21:17 帮助过:18人阅读
安装教程 https://www.cnblogs.com/xuqp/p/9172254.html
无法用navicat登录的解决方法
ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘password‘ PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER ‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘password‘; #更新一下用户的密码
FLUSH PRIVILEGES; #刷新权限
再重置下密码:alter user ‘root‘@‘localhost‘ identified by ‘123qwe‘;
---------------------
作者:5515
来源:CSDN
原文:https://blog.csdn.net/u010026255/article/details/80062153?utm_source=copy
版权声明:本文为博主原创文章,转载请附上博文链接!
添加用户:
create user "username"@"host" identified by "password";
安装mysql 8 及 修复登录错误日志
标签:错误 权限 ati root roo 原创文章 username 密码 规则