创建用户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