mysql常用操作命令

1.查看用户、密码、权限

select user,host,password  from mysql.user;

2.数据库备份权限受权

grant select,lock tables on *.* to backup@'localhost' identified by "bak123456"

3，刷新权限

flush privileges

4.创建数据库

create database jfedu001;