命令:
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
说明:
GRANT ALL PRIVILEGES ON database.table TO 'newuser'@'localhost'; GRANT ALL PRIVILEGES ON database.* TO 'newuser'@'localhost'; GRANT ALL PRIVILEGES ON *.* TO 'newuser'@'localhost';
REVOKE ALL PRIVILEGES ON database.table FROM 'username'@'host';
说明:
以下是最常用的MySQL权限列表: