- 创建用户
CREATE USER 'username'@'host' [IDENTIFIED BY 'password'];
GRANT privilege_type ON database_name.table_name TO 'username'@'host' IDENTIFIED BY 'password';
- 删除用户
DROP USER 'username'@'host';
- 密码修改
- root用户
SET PASSWORD FOR 'username'@'host'=PASSWORD('password');
- 普通用户
SET PASSWORD=PASSWORD('password');
- mysqladmin命令
mysqladmin -u root -p password=新密码，回车输入原密码
跳过密码：配置文件中添加skip-grant-tables，重启mysql服务
- 创建视图
CREATE VIEW view_name AS <SELECT 语句>;
