我知道以下命令可以允许远程IP登录MySQL:
GRANT select,insert,update,delete ON *.* TO root@"my_ip" IDENTIFIED BY "my_password";
FLUSH PRIVILEGES;
但是我如何列出可以登录MySQL的允许IP?
我知道以下命令可以允许远程IP登录MySQL:
GRANT select,insert,update,delete ON *.* TO root@"my_ip" IDENTIFIED BY "my_password";
FLUSH PRIVILEGES;
SELECT User, Host FROM mysql.user;
将显示所有用户及其在host列中允许的IP(范围)。
用户 | 主机 |
---|---|
user_LAN_3 | 192.168.1.3 |
user_DMZ_4 | 192.168.2.4 |
user_DMZ_ALL | 192.68.2.% |
user_LAN_DMZ_ALL | 192.168.% |
please_dont_do_that | % |
local_web_app | localhost |
mysql.infoschema | localhost |
mysql.session | localhost |
mysql.sys | localhost |
root | localhost |
sysadmin | localhost |