我有一台服务器(MySQL 8.0.21),它用不作为主机存在的名称替换主机名或地址,因此无法连接。一个例子:
PS G:\workspace> mysql -u root -p -h geolaptop
Enter password: ********
ERROR 1045 (28000): Access denied for user 'root'@'gut-monitor' (using password: YES)
P
或者
PS G:\workspace> mysql -u root -p -h 192.168.1.69
Enter password: ********
ERROR 1045 (28000): Access denied for user 'root'@'gut-monitor' (using password: YES)
PS G:\workspace>
我已经设置skip-name-resolve
为On
. 我查询过performance_schema.host_cache
:
mysql> use performance_schema;
Database changed
mysql> select * from host_cache;
Empty set (0.00 sec)
那么如何改变主机,或者更好的是,如何让它停止呢?
编辑:服务器的C:\Windows\System32\drivers\etc\hosts
:
...
127.0.0.1 match
127.0.0.1 diet
127.0.0.1 diet-fork
127.0.0.1 df2
127.0.0.1 pma
127.0.0.1 test
127.0.0.1 cr2
127.0.0.1 whodat
192.168.1.69 geolaptop
geolaptop的主机文件:
...
127.0.0.1 castlerockhoa
127.0.0.1 hw_errors
192.168.1.76 gwb-10
192.168.1.76 diet-fork
192.168.1.76 gut-monitor