本篇文章給大家帶來的內容是關于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