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
- navicat無法連線遠端的mysql--Host ‘xx.xx.xx.xx‘ 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
- 連線mysql時提示is not allowed to connect不允許連線MySql
- Navicat 連線 MySQL 失敗:2002-can‘t connect to server on localhost(10061)問題解決MySqlServerlocalhost
- 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
- MySQL 2003 - Can’t connect to MySQL server on (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
- Unable to execute SonarScanner analysis: Fail to get bootstrap index from server: Host is unreachable(Host unreachable)AIbootIndexServer
- 坑:ssh: connect to host github.com port 22: Connection refusedGithub