网站设计制作的服务和质量,烟台网站公司,创业商机网加工项目,深圳新公司注册流程及费用MySQL8.0.30一主两从复制与配置(一)_蜗牛杨哥的博客-CSDN博客
MySQL8.xx一主两从复制安装与配置
MySQL8.XX随未生成随机密码解决方案 一、客户端连接mysql#xff0c;问题#xff1a;1251 client does not support ... 二、解决
1.查看用户信息 备注#xff1a;host为 % … MySQL8.0.30一主两从复制与配置(一)_蜗牛杨哥的博客-CSDN博客
MySQL8.xx一主两从复制安装与配置
MySQL8.XX随未生成随机密码解决方案 一、客户端连接mysql问题1251 client does not support ... 二、解决
1.查看用户信息 备注host为 % 表示不限制ip localhost表示本机使用 plugin非mysql_native_password 则需要修改密码
2.修改用户密码
ALTER USER root% IDENTIFIED WITH mysql_native_password BY mysql123456; 更新user为roothost为% 的密码为mysql123456
ALTER USER rootlocalhost IDENTIFIED WITH mysql_native_password BY mysql123456; 更新user为roothost为localhost 的密码为mysql123456 mysql select host,user,plugin,authentication_string from mysql.user; ---------------------------------------------------------------------------------------------------------------------------- | host | user | plugin | authentication_string | ---------------------------------------------------------------------------------------------------------------------------- | % | root | caching_sha2_password | $A$005$!%^|vO |%DeGNFiUKOlWxW.xGZdRm1IMjAXqnFntAnn09aCdFMf3YzdB | | localhost | mysql.infoschema | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | | localhost | mysql.session | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | | localhost | mysql.sys | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | | localhost | root | caching_sha2_password | $A$005$_eU(!EbgRxf ;MUMSv8CCwlaJew7AIeBkTKUFyx9yokRQbm4KGB63o.0YA | ---------------------------------------------------------------------------------------------------------------------------- 5 rows in set (0.00 sec) mysql ALTER USER root% IDENTIFIED WITH mysql_native_password BY mysql123456; Query OK, 0 rows affected (0.01 sec) mysql ALTER USER rootlocalhost IDENTIFIED WITH mysql_native_password BY mysql123456; Query OK, 0 rows affected (0.01 sec) mysql select host,user,plugin,authentication_string from mysql.user; ---------------------------------------------------------------------------------------------------------------------------- | host | user | plugin | authentication_string | ---------------------------------------------------------------------------------------------------------------------------- | % | root | mysql_native_password | *CAAA3AD851D5FFA9E5BDB96CA06F73633A3BA831 | | localhost | mysql.infoschema | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | | localhost | mysql.session | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | | localhost | mysql.sys | caching_sha2_password | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED | | localhost | root | mysql_native_password | *CAAA3AD851D5FFA9E5BDB96CA06F73633A3BA831 | ---------------------------------------------------------------------------------------------------------------------------- 5 rows in set (0.00 sec) 再次连接即可
