MySQL錯誤1042-Can't get hostname for your address
近來使用Navicat for MySQL連線遠端的MySQL伺服器,卻提示:Can't get hostname for your address 明明已經使用grant命令授權過了的呀。
解決方法如下:
編輯my.ini
在[mysqld]節點下新增或修改如下兩行行
skip-name-resolve #忽略主機名的方式訪問
lower_case_table_names=1 #忽略資料庫表名大小寫
重啟mysql服務,問題得到解決。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29119536/viewspace-1756702/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL錯誤1042-Can't get hostname for your address解決方法MySql
- can't assign requested address 錯誤解決
- Can't Connect to MySQL Server on IP Address (10061) 錯誤的解決方案MySqlServer
- 錯誤內容:You have an error in your SQL syntax; check the manual that corresponds to your MySQL serverErrorMySqlServer
- 【Redis】錯誤:failed: Hostname must not be empty or nullRedisAINull
- anacond 或python3 報check_hostname requires server_hostname錯誤PythonUIServer
- 連線MySQL錯誤:Can't connect to MySQL server (10060)MySqlServer
- Java Get local IP addressJava
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock錯誤MySqlServer
- MYSQL報1022錯誤:Can't write;duplicate key in table '.....'MySql
- 【MySQL】Can't get stat of './mysql/slow_log.CSV' (Errcode: 2)MySql
- Get your Windows product key from a scriptWindows
- vncserver: couldn't find "xauth" on your PATHVNCServer
- MySQL 5.7向表匯入資料包錯"ERROR 13 (HY000): Can't get stat of"MySqlError
- Mysql錯誤集MySql
- yii2 Unable to verify your data submission錯誤解決
- RMAN的"rman: can't open target"錯誤
- vncserver: couldn't find "xauth" on your PATH.VNCServer
- MySQL 錯誤程式碼MySql
- MySQL 常見錯誤MySql
- MySQL error 錯 誤 碼MySqlError
- mysql 一個錯誤MySql
- mysql slave錯誤skipMySql
- mysql 啟動錯誤MySql
- 切換分支 error: Your local changes tby checkout: 錯誤解決方法Error
- mysql錯誤詳解(1819):ERROR 1819 (HY000): Your password does not satisfy the current policy requirementsMySqlErrorUIREM
- Dubbo廣播模式下報錯:Can't assign requested address解決辦法模式
- MySQL 啟動報錯 Table 'mysql.plugin' doesn't existMySqlPlugin
- MySQL2059錯誤MySql
- MySQL錯誤程式碼大全MySql
- mysql replication常見錯誤MySql
- MySQL 跳過同步錯誤MySql
- 【vnc】vncserver: couldn't find "xauth" on your PATH 問題VNCServer
- Linux環境下MySQL報Table 'xxx' doesn't exist錯誤解決方法LinuxMySql
- wget下載安裝時出現錯誤doesn‘t match requested host name錯誤wget
- Hive錯誤:Unable to load native-hadoop library for your platformHiveHadoopPlatform
- Ubuntu學習之apt-get update 升級錯誤Ubuntuapt-get
- MySQL錯誤之mysql.slave_master_infoMySqlAST