navicat錯(cuò)誤1251

2910

navicat錯(cuò)誤1251

　　navicat在連接MySQL8.0及以上版本的時(shí)候，總是報(bào)錯(cuò)1251；原因是MySQL8.0版本的加密方式和MySQL5.0的不一樣，連接會(huì)報(bào)錯(cuò)。下面就為大家介紹一下詳細(xì)的解決辦法。

推薦教程：MySQL數(shù)據(jù)庫(kù)入門視頻教程

1、先通過(guò)命令行進(jìn)入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、更改密碼：該例子中 123為新密碼

mysql>?ALTER?USER?'root'@'localhost'?IDENTIFIED?WITH?mysql_native_password?BY?'123'; Query?OK,?0?rows?affected?(0.35?sec)

4.刷新：

mysql>?FLUSH?PRIVILEGES; Query?OK,?0?rows?affected?(0.28?sec)

　　// 如果報(bào)錯(cuò)ERROR 1396 (HY000): Operation ALTER USER failed for ‘root’@’%’：

　　則是遠(yuǎn)程訪問(wèn)權(quán)限不正確，先選擇數(shù)據(jù)庫(kù)，查看一下再更改：

mysql>?use?mysql; Database?changed mysql>?select?user,host?from?user; +------------------+-----------+ |?user?????????????|?host??????| +------------------+-----------+ |?mysql.infoschema?|?localhost?| |?mysql.session????|?localhost?| |?mysql.sys????????|?localhost?| |?root?????????????|?localhost?| +------------------+-----------+ 5?rows?in?set?(0.00?sec)

　　最后重新啟動(dòng)MySQL服務(wù)，在重新連接就行了。

以上就是

? 版權(quán)聲明
THE END
數(shù)據(jù)庫(kù)
# navicat
喜歡就支持一下吧
點(diǎn)贊10 分享