navicat 控制mysql某个数据库只属于某个用户

CREATE USER ‘test02‘@‘localhost‘ IDENTIFIED BY ‘test‘;

GRANT SELECT, INSERT, UPDATE, REFERENCES, DELETE, CREATE, DROP, ALTER, INDEX, CREATE VIEW, SHOW VIEW ON `test`.* TO ‘test02‘@‘localhost‘;

flush privileges;


参考链接：http://blog.csdn.net/u010514052/article/details/51104659

navicat 控制mysql某个数据库只属于某个用户

标签：出现   alter   password   列表   lib   host   控制   数据库   grant