mysql 一个账户能授权几个ip

使用以下授权语句，将授权指定的192.168.1.1 和192.168.1.2 的机器，使用用户名为root，密码为test123的用户访问grant all privileges on *.* to 'root'@'192.168.1.1' identified by 'test123'grant all privileges on *.* to 'root'@'192.168.1.2' identified by 'test123'

GRANT ALL PRIVILEGES ON `mydb`.* TO 'root'@'192.168.%.%' identified by 'mypwd' WITH GRANT OPTION

GRANT ALL PRIVILEGES ON `mydb`.* TO 'root'@'10.111.1.80' identified by 'mypwd' WITH GRANT OPTION

GRANT ALL PRIVILEGES ON `mydb`.* TO 'root'@'172.%.%.%' identified by 'mypwd' WITH GRANT OPTION

FLUSH PRIVILEGES

不可以用逗号分隔，只能多次授权。

数据库mysql下user表会显示多条授权记录

---