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服務,就可以了。
相關文章
- “Host ‘xxxx‘ is not allowed to connect to this MySQL server“MySqlServer
- Host 'xxx' is not allowed to connect to this MySQL server.MySqlServer
- MySQL-1130-host ... is not allowed to connect to this MySql serverMySqlServer
- Host 'xxx' is not allowed to connect to this MySQL server 解決方法MySqlServer
- Navicat連線centos裡mysql報錯Host is not allowed to connect to this MySQL serverCentOSMySqlServer
- 解決MySql報錯:1130 - Host ‘xxx‘ is not allowed to connect to this MySQL server的方法MySqlServer
- 虛擬機器NAT模式下連線mysql報錯:Host '192.168.30.1' 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
- ssh: connect to host localhost port 22: Connection refusedlocalhost
- 關於對連線資料庫時出現1130-host “**” is not allowed to connect to this MySql/mariadb server 的錯誤解決方法資料庫MySqlServer
- Navicat 連線 MySQL 失敗:2002-can‘t connect to server on localhost(10061)問題解決MySqlServerlocalhost
- 連線mysql時提示is not allowed to connect不允許連線MySql
- MySQL 2003 - Can’t connect to MySQL server on (10060)MySqlServer
- telnet localhost 44444 telnet: connect to address ::1: Connection refusedlocalhost
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock錯誤MySqlServer
- mysql 啟動報錯Can't connect to local MySQL server through socket '/data/mysql/mysql/mysql.sock'(111)MySqlServer
- Server Tomcat v9.0 Server at localhost failed to start.ServerTomcatlocalhostAI
- nested exception is io.lettuce.core.RedisConnectionException: Unable to connect to localhost:6379ExceptionRedislocalhost
- Can't Connect to MySQL Server on IP Address (10061) 錯誤的解決方案MySqlServer
- 坑:ssh: connect to host github.com port 22: Connection refusedGithub
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- 異常解決——GitLab : ssh: connect to host port 22: Connection refusedGitlab
- Unable to execute SonarScanner analysis: Fail to get bootstrap index from server: Host is unreachable(Host unreachable)AIbootIndexServer
- 解決Windows 2012 Server的localhost解析為::1WindowsServerlocalhost
- 虛擬機器之間能夠ping通,但是建立tcp連線時卻顯示Failed in connect to TCP server: No route to host虛擬機TCPAIServer
- http-server快速啟動localhost與iPhone X相容HTTPServerlocalhostiPhone
- 關於解決Server Tomcat v9.0 Server at localhost failed to start的問題ServerTomcatlocalhostAI
- linux下連線mysql報錯ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysqLinuxMySqlErrorServer
- HTTP_HOST 和 SERVER_NAME 的區別HTTPServer
- web server apache tomcat11-06-Host Manager AppWebServerApacheTomcatAPP
- ubuntu mysql Access denied for user root@localhostUbuntuMySqllocalhost
- DELL R900伺服器上基於REDHAT 4.6安裝oracle中碰到的Can't connect to X11 window server using 'localhost:0.0'伺服器RedhatOracleServerlocalhost
- Identity Server 4 預備知識 -- OpenID Connect 簡介IDEServer
- Connect SQL Server from Linux Client using Windows Authentication and troubleshoot stepsSQLServerLinuxclientWindows
- The connection to the server 10.10.0.2:6443 was refused - did you specify the right host or port?Server
- mysql 1045, "Access denied for user 'root'@'localhost' (using password: NO)"MySqllocalhost
- SQL Server CDC配合Kafka Connect監聽資料變化SQLServerKafka