用户管理与授权

查看用户信息： select user,host,plugin from mysql.user;

创建用户示例： create user 'stu'@'localhost' identified by '123456';

创建用户指定加密方式 示例：create user 'stu1'@'localhost' identified WITH mysql_native_password by '123456';

更新用户密码，指定加密方式，注意密码强度大小写数字：
ALTER user 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

授权用户对那些数据库的那些表可以进行操作 示例：
GRANT SELECT ON database_name.table_name TO 'user_name'@'localhost';
GRANT INSERT ON database_name.table_name TO 'user_name'@'localhost';
GRANT ALL ON database_name.table_name TO 'user_name'@'localhost';
GRANT ALL PRIVILEGES ON *.* TO 'user_name'@'%'; -- * 表示任意所有库、所有表，%表示任意地址
GRANT REPLICATION SLAVE ON *.* to 'mslave'@'192.168.131.1';#复制权限

删除用户：drop user 'name'@'localhost';