1.mysql创建用户
create user wms_test@'%' identified by '密码';
select user,host from mysql.user;
alter user wms_test@'%' identified by '密码';
drop user wms_test@'%';
2.权限管理
ALL:
SELECT,INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE;
ALL :
with grant option:
*.*
mysql.*
mysql.user
grant 权限列表 on 作用目标 to wms_test@'%' identified by '密码' with grant option;
show grants for wms_test@'%';
revoke 权限列表 on 作用目标 from wms_test@'%';