创建MySQL用户

1.登录mysql

mysql -uroot -proot123

2.创建新用户

create user 'student'@'%';

3.查询用户

select user,host,authentication_string

from mysql.user

where user='student';

4.修改密码

alter user 'student'@'%' identified by 'NewPass';

5.每小时最大连接数不能超过2个

alter user 'student'@'%' with max_connections_per_hour 2;

6.密码30天过期

alter user 'student'@'%' password expire interval 30 day;

7.密码过期

alter user 'student'@'%' password expire;

设置过期后，登录不错报，登录后执行任何命令提示修改密码?否则不能执行任何命令。

8.查询用户

select * from mysql.user

where user='student'

and host='%'\G

9.删除用户

drop user 'student'@'%';