MySQL有關1042 Can’t get hostname for your address的問題分析解決過程

[Comment 1]

前同事企鵝上面說他安裝的mysql 5.5，發現用mysql客戶端遠程連接的時候，報1042-Can’t get hostname for your address錯誤，但是權限已經grant了并且grant成功了。

這個報錯的意思是“您的地址無法獲得主機名”，我就想到了skip-name-resolve參數。

官方文檔:

--skip-name-resolve

Use IP addresses rather than host names when creating grant table entries. This option can be useful if your DNS does not work.

--skip-name-resolve

Do not resolve host names when checking client connections. Use only IP numbers. If you use this option, all Host column values in the grant tables must be IP numbers or localhost. See Section 7.7.11, “How MySQL Uses DNS”.

mysql> show variables like '%skip_name_resolve%';+-------------------+-------+| Variable_name | Value |+-------------------+-------+| skip_name_resolve | ON |+-------------------+-------+1 row in set (0.00 sec)mysql> set global skip_name_resolve=0;ERROR 1238 (HY000): Variable 'skip_name_resolve' is a read only variablemysql> 

失敗了，看來是只有修改my.cnf了

在[mysqld]節點下修改

skip-name-resolve#忽略主機名的方式訪問lower_case_table_names=1#忽略數據庫表名大小寫

重啟MySQLD process即可。

[Comment 2]

前同事企鵝留言：

mysql -h 192.168.1.101 -u root -p

訪問不了，我本地的mysql.192.168.1.101是本地ip地址。

grant all privileges on *.* to 'hive'@'192.168.1.101' identified by 'hive' with grant option;就是報連接不上，權限問題，怎么搞定。

查看官方文檔：

hostname

Variable Name hostname

Variable Scope Global

Dynamic Variable No

Permitted Values

Type string

The server sets this variable to the server host name at startup.

[html] mysql> show variables like '%hostname%'; +---------------+-------------------------------------------+ | Variable_name | Value | +---------------+-------------------------------------------+ | hostname | xxxxx.china.online.xx.com | +---------------+-------------------------------------------+ 1 row in set (0.00 sec) mysql> set global hostname='xxxxx2.china.online.xx.com'; ERROR 1238 (HY000): Variable 'hostname' is a read only variable mysql> 

失敗了，只有修改my.cnf了，在mysqld選項下面

[mysqld]# 注釋掉參數即可，mysql直接用本機ip不能訪問# hostname

然后重啟mysqld 服務即可。

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com