mysql
白手小弟
这个作者很懒,什么都没留下…
展开
-
Navicat Premium链接MySQL时出现2059错误
1、修改root更改加密方式ALTER USER 'root'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;修改密码ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';我这里的‘root’@'%'的百分号是因为user数据库中root的host数据是百分号,因此这里需要更换成%号,要不然会报错。刷新权限FLUSH PRI...原创 2022-05-10 10:50:29 · 504 阅读 · 0 评论 -
MySQL执行更改密码类型命令报错ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@‘localhost
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;1、问题是mysql中user表中显示host是%号,所以这里的localhost 更换成%即可select Host,user from user;原创 2022-05-10 10:43:51 · 5181 阅读 · 2 评论