创建用户 create user 'username'@'host' IDENTIFIED BY 'PASSWORD' 给指定用户授权 grant all on DBName.* to 'username'@'host' 刷新权限 flush privileges; 查看用户权限 show grants for 'user'@'host' 换行查询信息，主要针对多行 select * from user \G
