作者:甩小三弃小四 | 来源:互联网 | 2018-04-19 10:53
创建用户createuser#39;username#39;@#39;host#39;IDENTIFIEDBY#39;PASSWORD#39;给指定用户授权grantallonDBName.*to#39;username#39;@#39;host#39;刷新权限flushprivileges;查...
创建用户
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