MySQL用户创建、密码、授权、导出

– 查询用户信息
select host,user,password from mysql.user;
– 创建用户
CREATE USER ‘rw_user’@‘%’ IDENTIFIED BY ‘123456’;

– 查看当前用户权限
show grants;
– 查看某个用户权限

– 授权，记得刷新
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,INDEX ON . TO ‘rw_user’@‘%’;
– 删除权限，记得刷新
revoke all ON . from ‘rw_user’@‘%’;

– 刷新权限
flush privileges
– 修改密码
update mysql.user set password=password(‘abc’) where user = ‘rw_user’

– 5.7版本一下没有password字段
update mysql.user set authentication_string=password(‘abc’) where user=‘dbuser’;

– 修改安全模式
set sql_safe_updates=1;

– 查看编码集
show variables like ‘character%’

– 导出某个数据库
mysqldump -h124.70.94.117 -uroot -p123456 --opt -R --default-character-set=utf8 file_center>/opt/mysqlbackup/file_center.sql