易学笔记-mysql常用命令

1. 命令行登录：mysql -uroot -p
2. 创建数据库：CREATE DATABASE mysql2;
3. 创建用户：CREATE USER 用户名@'localhost' IDENTIFIED BY '密码';
4. 修改user01密码：SET PASSWORD FOR 'user01'@'localhost' = PASSWORD('新密码');
5. 授权所有权限：GRANT ALL PRIVILEGES ON 数据库名.* TO '用户名'@'localhost'; FLUSH PRIVILEGES;
6. user02查看权限，并修改密码：GRANT SELECT ON *.* TO 'user02'@'%' IDENTIFIED by 'password2';
7. 授权数据库并且新建用户和密码：GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER  ON mysql2.* TO mysqltest@localhost IDENTIFIED BY '123456';
8. 插入语句：insert into t_zd_sign_add_blank(`lang_type`, `sign`, `replace_sign`,`blank_flag`, `remark`) select `lang_type`, CONCAT(sign,'\\s'), sign,'1', `remark` from t_zd_sign_add_blank where blank_flag = '0';