常用命令

MySQL

用户与权限

1. 创建用户

CREATE USER 'username'@'host' IDENTIFIED BY 'password';

例子：

CREATE USER ‘wayne’@’%’ IDENTIFIED BY ‘123456’;

2. 赋予权限

GRANT privileges ON databaseName.tableName TO 'username'@'host';
GRANT privileges ON databaseName.tableName TO 'username'@'host' WITH GRANT OPTION;

例子:
GRANT SELECT, INSERT ON test.user TO ‘wayne’@’%’;
GRANT ALL ON . TO ‘wayne’@’%’;
GRANT ALL ON typecho.* TO ‘wayne’@’%’;

3. 删除权限

REVOKE privilege ON databasename.tablename FROM 'username'@'host';

例子:
REVOKE SELECT ON . FROM ‘wayne’@’%’;

4. 删除用户

DROP USER 'username'@'host';

5. 设置与更改用户密码

SET PASSWORD FOR 'username'@'host' = PASSWORD('newPassword');
如果是当前登陆用户用:
SET PASSWORD = PASSWORD("newPassword");

例子:
SET PASSWORD FOR ‘pig’@’%’ = PASSWORD(“123456”);

其他