mysql ERROR 1042 (00000): Can&＃39;t get hostname for your address 问题的解决。

远程连接本地数据库时碰到的问题。
问题&＃xff1a;mysql ERROR 1042 (00000): Can&＃39;t get hostname for your address
解决&＃xff1a;
1. 找到&＃xff1a;mysql安装目录下面&＃xff1a;my.ini
2. 添加如下语句 skip-name-resolve &＃xff08;添加地点不限&＃xff0c;建议添加在最后&＃xff09;
3. 重启mysql



格式&＃xff1a;grant 权限 on 数据库名.表名 用户&＃64;登录主机 identified by "用户密码";
mysql> grant all privileges on *.* to &＃39;root&＃39;&＃64;&＃39;%&＃39; identified by &＃39;&＃39; with grant option;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)