SQL

DCL(data control language)

Reference

创建用户

CREATE USER 'foo'@'localhost' IDENTIFIED BY 'password';

授予用户权限

GRANT ALL ON `db`.* TO 'foo'@'localhost';

回收用户权限

REVOKE ALL ON `db_name`.* FROM 'foo'@'localhost';

DDL(data definition language)

Reference

DML(data manipulation language)

Reference