# 查看用户列表
select host, user, authentication_string from mysql.user;
# 创建表空间
create user 'asemgr1'@'%' identified by 'asemgr1';
create user 'asemgr2'@'%' identified by 'asemgr2';
# 授予用户通过外网IP对于该数据库的全部权限
grant all privileges on `test`.* to 'test'@'%';
# 授予用户在本地服务器对该数据库的全部权限
grant all privileges on `test`.* to 'test'@'localhost';
grant select on test.* to 'user1'@'localhost'; /*给予查询权限*/
grant insert on test.* to 'user1'@'localhost'; /*添加插入权限*/
grant delete on test.* to 'user1'@'localhost'; /*添加删除权限*/
grant update on test.* to 'user1'@'localhost'; /*添加权限*/
# 刷新权限
flush privileges;