Host 'localhost' is not allowed to connect to this MySQL server
1、修改mysql的root密碼後，出現Host ‘localhost’ is not allowed to connect to this MySQL server 錯誤。
2、突然發神經，就報這個錯（我的就是這樣）
解決辦法：
找到mysql安裝目錄下的my.ini檔案
在[mysqld]下加下面兩行，
skip-name-resolve
skip-grant-tables
重啟mysql的windows服務，就可以了。
相關文章
- mysql遠端連線 Host * is not allowed to connect to this MySQL serverMySqlServer
- MySQL-1130-host ... is not allowed to connect to this MySql serverMySqlServer
- Host 'xxx' is not allowed to connect to this MySQL server.MySqlServer
- Host 'xxx' is not allowed to connect to this MySQL server 解決方法MySqlServer
- “Host ‘xxxx‘ is not allowed to connect to this MySQL server“MySqlServer
- Host is not allowed to connect to this MySQL server 錯誤的處理方法MySqlServer
- SQL Error (1130): Host IP is not allowed to connect to this MySQL serverErrorMySqlServer
- 報錯:1130-host ... is not allowed to connect to this MySql server 開放mysql遠端連線 不使用localhostMySqlServerlocalhost
- Navicat連線centos裡mysql報錯Host is not allowed to connect to this MySQL serverCentOSMySqlServer
- 解決mysql Navicat 出錯:1130-host . is not allowed to connect to this MySql server,MySqlServer
- 解決MySql報錯：1130 - Host ‘xxx‘ is not allowed to connect to this MySQL server的方法MySqlServer
- 上手MySQL之解決問題：not allowed to connect to this MySQL serverMySqlServer
- 虛擬機器NAT模式下連線mysql報錯：Host '192.168.30.1' is not allowed to connect to this MySQL server虛擬機模式MySqlServer
- ssh: connect to host localhost port 22: Connection refusedlocalhost
- ERROR 1130: Host ***.***.***.*** is not allowed to connect to this MySQL serverERROR 1062 (23000):ErrorMySqlServer
- mysql error 2005 - Unknown MySQL server host 'localhost'(11001）MySqlErrorServerlocalhost
- MySQL問題記錄--Can't connect to MySQL server on localhost (10061)解決方法MySqlServerlocalhost
- 關於對連線資料庫時出現1130-host “**” is not allowed to connect to this MySql/mariadb server 的錯誤解決方法資料庫MySqlServer
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)ErrorMySqlServerlocalhost
- Xtrabackup備份報錯Failed to connect to MySQL serverAIMySqlServer
- MySQL連線提示Can't connect to local MySQL server through socketMySqlServer
- Can't connect to local MySQL server through socket '/tmp/mysql.sock'MySqlServer
- Could not resolve host: 'localhost 報錯解決辦法localhost
- 異常：Can't connect to MySQL server (10060)MySqlServer
- 連線MySQL錯誤:Can't connect to MySQL server (10060)MySqlServer
- Server Tomcat v7.0 Server at localhost failed to startServerTomcatlocalhostAI
- 解決Can 't connect to local MySQL server through socket '/tmp/mysql.sock '(2) "MySqlServer
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock錯誤MySqlServer
- Server Tomcat v9.0 Server at localhost failed to start.ServerTomcatlocalhostAI
- Unable to connect to SQL Server ExpressSQLServerExpress
- mysql 啟動報錯Can't connect to local MySQL server through socket '/data/mysql/mysql/mysql.sock'(111)MySqlServer
- MySQL 5.5 關閉資料庫報錯"Can't connect to local MySQL server through socket"MySql資料庫Server
- 坑：ssh: connect to host github.com port 22: Connection refusedGithub
- MySQL報錯'ERROR 2002 (HY000): Can't connect to local MySQL server through'MySqlErrorServer
- telnet localhost 44444 telnet: connect to address ::1: Connection refusedlocalhost
- MySQL-undefinedfunctionmysql_connect()MySqlUndefinedFunction
- mysql connect speed is slowMySql
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)解決方法MySqlServer