池州网站建设,做彩票网站需要什么,内蒙古建设工程造价信息网,oa协同办公系统mysql8用navicat可视化连接会报错加密方式错误#xff0c;想要连接mysql8有两种方式1#xff1a;安装MySQL8客户端2#xff1a;修改MySQL8的密码加密方式我采用的是第二种#xff0c;因为服务器上是MySQL8#xff0c;而我本地是MySQL5#xff0c;不想在装一个MySQL8…mysql8用navicat可视化连接会报错加密方式错误想要连接mysql8有两种方式1安装MySQL8客户端2修改MySQL8的密码加密方式我采用的是第二种因为服务器上是MySQL8而我本地是MySQL5不想在装一个MySQL8要是换电脑还要在装一个MySQL8觉得有点麻烦。以下是通过查资料总结出来的修改方法以及修改过程中可能会出现的问题。时间有点久了查到的资料地址忘记了就剩了个修改记录。// 登陆mysql -uroot -p// 更改加密方式mysql ALTER USER [email protected]%‘ IDENTIFIED BY ‘password‘ PASSWORD EXPIRE NEVER;Query OK, 0 rows affected (0.02 sec)// 更改密码mysql ALTER USER ‘root‘‘%‘ IDENTIFIED WITH mysql_native_password BY ‘pwd12345‘;Query OK,0 rows affected (0.03 sec)// 刷新mysqlFLUSH PRIVILEGES;Query OK,0 rows affected (0.01 sec)// 如果报错 ERROR 1819 (HY000): Your password does not satisfy the current policy requirements使用以下mysql set global validate_password.policy0;Query OK,0 rows affected (0.00sec)mysql set global validate_password.length8;Query OK,0 rows affected (0.00 sec)// 如果报错 ERROR 1396 (HY000): Operation ALTER USER failed for [email protected]%‘mysqluse mysql;Database changedmysql select user,host fromuser;-----------------------------| user | host |-----------------------------| mysql.infoschema | localhost || mysql.session | localhost || mysql.sys | localhost || root | localhost |-----------------------------5 rows in set (0.00 sec)原文https://www.cnblogs.com/milude0161/p/9228295.html
