linux - Mysql 创建用户和授权

CREATE USER 'cui'@'%' IDENTIFIED BY 'xxxxxxxxxxxxxxxxxx';
GRANT ALL ON test_db.* TO 'cui'@'%';

REVOKE SELECT ON test_db.* FROM 'cui'@'%';

posted @ 2016-01-27 22:52  LightingCui  阅读(225)  评论(0编辑  收藏  举报