mysql限制不同的用户访问不同的数据库

-- 1.进入mysql的bin目录
mysql -uusername -ppassword
-- 2.登录成功后，进入mysql数据库
USE mysql
-- 3.创建新用户
CREATE USER 'mpps'@'localhost' IDENTIFIED BY 'mpps'
修改密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
-- 4.为新用户赋予权限
GRANT SELECT, INSERT, UPDATE, REFERENCES, DELETE, CREATE, DROP, ALTER, INDEX, CREATE VIEW, SHOW VIEW ON `test`.* TO 'mpps'@'localhost';
||
grant all privileges on *.* to 'root'@'%' with grant option;
-- 5.刷新权限
FLUSH PRIVILEGES;