mysql

mysql.md

作成

GRANT usage ON `database1`.* TO 'user'@'localhost' IDENTIFIED BY 'password';
GRANT insert,select ON `database1`.comments TO 'user'@'localhost';
FLUSH PRIVILEGES;

権限削除

REVOKE ALL on *.* from 'user'@'%';
REVOKE ALL on *.* from 'user'@'localhost';
FLUSH PRIVILEGES;

ユーザー削除

DROP USER 'user'@'%';
DROP USER 'user'@'localhost';