摘要:
添加用户:CREATE USER 'made'@'%' IDENTIFIED BY 'password';
授权命令:GRANT ALL PRIVILEGES ON school.* TO 'made'@'%';
授予select权限:GRANT SELECT ON school.* TO 'made'@'%';
剥夺权限:REVOKE ALL PRIVILEGES ON school.* FROM 'made'@'%';
刷新权限表:FLUSH PRIVILEGES;
删除用户:DROP USER 'made'@'%'; 阅读全文
posted @ 2018-04-12 18:53
蓝天白云飘飘
阅读(132)
评论(0)
推荐(0)

浙公网安备 33010602011771号