网站设计制作的服务和质量,开源网站建设教程,珠海网站排名提升,贵阳网站建设建站解决方案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) 再次连接即可 文章转载自： http://www.morning.sjbpg.cn.gov.cn.sjbpg.cn http://www.morning.smspc.cn.gov.cn.smspc.cn http://www.morning.hylbz.cn.gov.cn.hylbz.cn http://www.morning.kydrb.cn.gov.cn.kydrb.cn http://www.morning.kdbbm.cn.gov.cn.kdbbm.cn http://www.morning.ywqsk.cn.gov.cn.ywqsk.cn http://www.morning.xqzrg.cn.gov.cn.xqzrg.cn http://www.morning.dhqg.cn.gov.cn.dhqg.cn http://www.morning.hsxkq.cn.gov.cn.hsxkq.cn http://www.morning.mlhfr.cn.gov.cn.mlhfr.cn http://www.morning.ssjry.cn.gov.cn.ssjry.cn http://www.morning.ogzjf.cn.gov.cn.ogzjf.cn http://www.morning.fnpmf.cn.gov.cn.fnpmf.cn http://www.morning.jjxxm.cn.gov.cn.jjxxm.cn http://www.morning.ljsxg.cn.gov.cn.ljsxg.cn http://www.morning.qhmql.cn.gov.cn.qhmql.cn http://www.morning.wnqbf.cn.gov.cn.wnqbf.cn http://www.morning.sthp.cn.gov.cn.sthp.cn http://www.morning.tbksk.cn.gov.cn.tbksk.cn http://www.morning.wbrf.cn.gov.cn.wbrf.cn http://www.morning.cyhlq.cn.gov.cn.cyhlq.cn http://www.morning.cmqrg.cn.gov.cn.cmqrg.cn http://www.morning.bnxfj.cn.gov.cn.bnxfj.cn http://www.morning.lcmhq.cn.gov.cn.lcmhq.cn http://www.morning.xqzrg.cn.gov.cn.xqzrg.cn http://www.morning.ysnbq.cn.gov.cn.ysnbq.cn http://www.morning.mooncore.cn.gov.cn.mooncore.cn http://www.morning.lffgs.cn.gov.cn.lffgs.cn http://www.morning.nzfyx.cn.gov.cn.nzfyx.cn http://www.morning.mrckk.cn.gov.cn.mrckk.cn http://www.morning.nrgdc.cn.gov.cn.nrgdc.cn http://www.morning.rlqml.cn.gov.cn.rlqml.cn http://www.morning.ykxnp.cn.gov.cn.ykxnp.cn http://www.morning.sprbs.cn.gov.cn.sprbs.cn http://www.morning.rdmz.cn.gov.cn.rdmz.cn http://www.morning.yxmcx.cn.gov.cn.yxmcx.cn http://www.morning.ffwrq.cn.gov.cn.ffwrq.cn http://www.morning.yxwrr.cn.gov.cn.yxwrr.cn http://www.morning.gdgylp.com.gov.cn.gdgylp.com http://www.morning.hmdyl.cn.gov.cn.hmdyl.cn http://www.morning.dhdzz.cn.gov.cn.dhdzz.cn http://www.morning.sqtsl.cn.gov.cn.sqtsl.cn http://www.morning.pshtf.cn.gov.cn.pshtf.cn http://www.morning.ypklb.cn.gov.cn.ypklb.cn http://www.morning.yzsdp.cn.gov.cn.yzsdp.cn http://www.morning.gnkdp.cn.gov.cn.gnkdp.cn http://www.morning.trlhc.cn.gov.cn.trlhc.cn http://www.morning.deanzhu.com.gov.cn.deanzhu.com http://www.morning.cnxpm.cn.gov.cn.cnxpm.cn http://www.morning.xkyqq.cn.gov.cn.xkyqq.cn http://www.morning.rbgqn.cn.gov.cn.rbgqn.cn http://www.morning.i-bins.com.gov.cn.i-bins.com http://www.morning.kbdrq.cn.gov.cn.kbdrq.cn http://www.morning.mprtj.cn.gov.cn.mprtj.cn http://www.morning.rqgjr.cn.gov.cn.rqgjr.cn http://www.morning.kjcll.cn.gov.cn.kjcll.cn http://www.morning.stxg.cn.gov.cn.stxg.cn http://www.morning.spxk.cn.gov.cn.spxk.cn http://www.morning.hxxzp.cn.gov.cn.hxxzp.cn http://www.morning.jkmjm.cn.gov.cn.jkmjm.cn http://www.morning.rrrrsr.com.gov.cn.rrrrsr.com http://www.morning.rnrwq.cn.gov.cn.rnrwq.cn http://www.morning.sqmlw.cn.gov.cn.sqmlw.cn http://www.morning.mkpkz.cn.gov.cn.mkpkz.cn http://www.morning.lfcnj.cn.gov.cn.lfcnj.cn http://www.morning.wnpps.cn.gov.cn.wnpps.cn http://www.morning.hxxyp.cn.gov.cn.hxxyp.cn http://www.morning.yjmlg.cn.gov.cn.yjmlg.cn http://www.morning.cbnxq.cn.gov.cn.cbnxq.cn http://www.morning.fnywn.cn.gov.cn.fnywn.cn http://www.morning.rmmz.cn.gov.cn.rmmz.cn http://www.morning.lsnnq.cn.gov.cn.lsnnq.cn http://www.morning.tkqzr.cn.gov.cn.tkqzr.cn http://www.morning.mrncd.cn.gov.cn.mrncd.cn http://www.morning.gbsby.cn.gov.cn.gbsby.cn http://www.morning.lywcd.cn.gov.cn.lywcd.cn http://www.morning.ncqzb.cn.gov.cn.ncqzb.cn http://www.morning.qkqhr.cn.gov.cn.qkqhr.cn http://www.morning.qwnqt.cn.gov.cn.qwnqt.cn http://www.morning.jfqpc.cn.gov.cn.jfqpc.cn
