mysql授权命令演示

1：创建数据库

CREATE DATABASE testDb  CHARACTER SET utf8 COLLATE utf8_general_ci;

2：创建用户并授权

grant all on  testDb.*  to  'test_user'@'%' identified by  'test_user';

3：刷新权限

flush  privileges;

4：查看授权

show  grants for   'test_user'@'%';

补充说明：
局域网授权的写法：test@‘192.168.10.%’;

mysql的全部权限：
SELECT, INSERT,UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX,
ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW,
SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER

删除用户：drop user ‘test_user’@’%’;