mysql建库语句

1. 创建数据库

CREATE  DATABASE  ss_sysright   DEFAULT  CHARACTER  SET  UTF8 COLLATE UTF8_GENERAL_CI;

2.  创建用户

@'localhost'(本地访问Only) @'%'(可以外部访问)
CREATE user  'workuser'@'localhost' IDENTIFIED BY 'Work@123';
CREATE user  'workuser'@'%' IDENTIFIED  BY 'Work@123';

3. 授权用户CRUD以及创建表的权限

GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE, ALTER ROUTINE ON ss_sysright.* TO 'workuser'@'%';

4. 授权用户CRUD以及创建表的权限

GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE, ALTER ROUTINE ON ss_sysright.* TO 'workuser'@'localhost';

5. 授权用户CRUD以及创建表的权限

GRANT SELECT ON mysql.`user` TO 'workuser'@'%';

6. 授权用户CRUD以及创建表的权限

GRANT SELECT ON mysql.`user` TO 'workuser'@'localhost';

7. 移除权限

 

revoke CREATE ON `iotbusiness123`.* FROM 'workuser'@'localhost';
revoke CREATE ON `iotbusiness123`.* FROM 'workuser'@'%';

9. 查看权限

show grants for 'workuser'@'%';
show grants for 'workuser'@'localhost';

10. 立即启用修改

FLUSH PRIVILEGES;