摘要:
添加用户: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'@'%'; 阅读全文