MySQL資料庫的安裝教程及相關問題

標籤：mysq   color   his   安裝   toc   details   遠程   nat   get   

MySQL資料庫的安裝教程及相關問題

2018-07-13

MySQL資料庫的下載及安裝教程

問題1：mysql遠端連線 Host * is not allowed to connect to this MySQL server

MySQL 8.0 Command Line Client - Unicode 

use mysql;select host,user from user where user=‘root‘;update user set host =‘%‘where user =‘root‘;

重啟服務使其生效

問題2：navicat 串連 mysql 出現1251Client does not support authentication protocol requested by server的解決方案

MySQL 8.0 Command Line Client - Unicode 

ALTER USER ‘root‘@‘%‘ IDENTIFIED WITH mysql_native_password BY ‘[email protected]‘;

重啟服務使其生效

MySQL資料庫的安裝教程及相關問題