本篇文章給大家帶來的內容是關于navicat連接mysql8.0的方法（有效），有一定的參考價值，有需要的朋友可以參考一下，希望對你有所幫助。
今天下了個 MySQL8.0，發現navicat連接不上，總是報錯1251；
原因是MySQL8.0版本的加密方式和MySQL5.0的不一樣，連接會報錯。
試了很多種方法，終于找到一種可以實現的：
更改加密方式
1.先通過命令行進入mysql的root賬戶：
PS?C:Windowssystem32>?mysql?-uroot?-p
再輸入root的密碼：
Enter?password:?****** Welcome?to?the?MySQL?monitor.??Commands?end?with?;?or?g. Your?MySQL?connection?id?is?18 Server?version:?8.0.11?MySQL?Community?Server?-?GPL Copyright?(c)?2000,?2018,?Oracle?and/or?its?affiliates.?All?rights?reserved. Oracle?is?a?registered?trademark?of?Oracle?Corporation?and/or?its affiliates.?Other?names?may?be?trademarks?of?their?respective owners. Type?'help;'?or?'h'?for?help.?Type?'c'?to?clear?the?current?input?statement. mysql>
2.更改加密方式：
mysql>?ALTER?USER?'root'@'localhost'?IDENTIFIED?BY?'password'?PASSWORD?EXPIRE?NEVER; Query?OK,?0?rows?affected?(0.10?sec)
?3.更改密碼：
mysql>?ALTER?USER?'root'@'localhost'?IDENTIFIED?WITH?mysql_native_password?BY?'password'; Query?OK,?0?rows?affected?(0.35?sec)
4.刷新：
mysql>?FLUSH?PRIVILEGES; Query?OK,?0?rows?affected?(0.28?sec)
// 如果報錯? ?ERROR 1396 (HY000): Operation ALTER USER failed for ‘root’@’%’?：
則是遠程訪問權限不正確，先選擇數據庫，查看一下再更改：
mysql>?use?mysql; Database?changed mysql>?select?user,host?from?user; +------------------+-----------+ |?user?????????????|?host??????| +------------------+-----------+ |?mysql.infoschema?|?localhost?| |?mysql.session????|?localhost?| |?mysql.sys????????|?localhost?| |?root?????????????|?localhost?| +------------------+-----------+ rows?in?set?(0.00?sec)
? 版權聲明
文章版權歸作者所有，未經允許請勿轉載。
THE END
