创建普通用户teacher 密码123456
CREATE USER 'teacher' @localhost IDENTIFIED BY '123456';
创建用户student
CREATE USER 'student' @localhost;
查看已存在的用户
Use mysql;
SELECT HOST,USER,PASSWORD,select_priv,INSERT_priv,update_priv,delete_priv FROM user\G;
2、Grant创建用户并授权
GRANT INSERT,SELECT ON school0306.student TO 'xiaoming'@'localhost' IDENTIFIED BY '123456';
也可以使用该语句位已创建的用户授权。
GRANT SELECT ON school0306.view_student TO 'student'@'localhost';