MySQL error 1042-can t get hostname to your address solution

Installed MySQL 5.5, found remote connection with the MySQL client, reported 1042-can ' t get hostname for the your address error, while the connection user has been authorized. This error means "your address can not get host name", I thought of the skip-name-resolve parameters.

The workaround is as follows:

Edit My.ini
Add or modify the following two lines under the [MYSQLD] node
Skip-name-resolve #忽略主机名的方式访问
Lower_case_table_names=1 #忽略数据库表名大小写

Restart the MySQL service and the problem is resolved.