Mysql 授权

显示所有用户

SELECT Host,User FROM mysql.user;

创建数据库并授权

CREATE DATABASE IF NOT EXISTS `notice`;

创建新用户

set global validate_password_policy=0;
CREATE USER 'notice_w'@'%' IDENTIFIED BY 'secret';
GRANT ALL PRIVILEGES ON *.* TO 'notice_w'@'%';

CREATE USER 'notice_r'@'%' IDENTIFIED BY 'secret';
GRANT USAGE ON *.* TO 'notice_r'@'%';

授权用户

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES ON `notice`.* TO 'notice_w'@'%';
GRANT SELECT ON `notice`.* TO 'notice_r'@'%';

删除用户

DELETE FROM user WHERE User="notice_w";
DELETE FROM user WHERE User="notice_r";
flush privileges;