MySQL5.7 查询用户,配置IP限制

1) MySQL 查询现在所有用户
 select host,user from user;
 Navicat点击用户标签 查询;
2) 

GRANT ALL PRIVILEGES ON *.* TO 'emspro'@'10.112.84.1' IDENTIFIED BY 'xxxx' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'emspro'@'10.112.84.2' IDENTIFIED BY 'xxxx' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'emspro'@'10.112.84.3' IDENTIFIED BY 'xxxx' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'emspro'@'10.112.68.23' IDENTIFIED BY 'xxxx' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'emspro'@'10.112.68.24' IDENTIFIED BY 'xxxx' WITH GRANT OPTION;

 

flush privileges;

转载于:https://www.cnblogs.com/sos-blue/p/8952062.html