连接到MySQL
mysql -h [host] -u[root] -p[password] -D[databaseName]
查看及授权
show grants for [user]
grant all privileges on[databaseName]
.* to '[user]'@'%';
回收权限
revoke all privileges on
[databaseName]
.* from '[user]'@'%';
刷新以上配置
flush privileges;
网友评论