创建用户名为test_q,密码为123456
CREATE USER 'test_q' IDENTIFIED BY '123456';
查询该数据库空间的所有用户
SELECT USER,HOST from mysql.user;
查看用户权限
SHOW GRANTS FOR 'test_q'
赋予用户只有查询权限
GRANT SELECT on redmine.* to 'test_q'@'%';
赋予用户test_user增，删，改，查
GRANT INSERT,DELETE,UPDATE,SELECT on test_database.* to 'test_user'@'%';
赋予用户所有权限
GRANT ALL PRIVILEGES on test_database.* to 'test_user'@'%';
刷新权限
FLUSH PRIVILEGES;
删除用户
DROP USER test_q@'%';
