?MySQL8.0.30一主兩從復(fù)制與配置(一)_蝸牛楊哥的博客-CSDN博客

MySQL8.xx一主兩從復(fù)制安裝與配置

MySQL8.XX隨未生成隨機(jī)密碼解決方案

一、客戶端連接mysql，問(wèn)題：1251 client does not support ...

?二、解決

1.查看用戶信息

備注：host為 % 表示不限制ip??? localhost表示本機(jī)使用??? plugin非mysql_native_password 則需要修改密碼

2.修改用戶密碼

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'mysql123456';
更新user為root，host為% 的密碼為mysql123456

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysql123456';
更新user為root，host為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 'root'@'localhost' 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)
?

再次連接即可：

? ? ? ? ? ? ? ? ? ? ? ???文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-684925.html

到了這里，關(guān)于MySQL8.xx 解決1251 client does not support ..解決方案的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！