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;