连接数据库
mysql -uuser -ppassword -hhost
查询数据库版本
select version() ;
创建用户
CREATE USER username IDENTIFIED BY ‘password’ ;
修改用户密码
SET PASSWORD FOR username=PASSWORD(‘password1’);
OR
ALTER USER ‘username’@‘localhost’ IDENTIFIED BY ‘password2’ ;
// 修改密码过期默认使用全局策略
ALTER USER ‘user1’@‘%’ PASSWORD EXPIRE DEFAULT;
// 密码30天过期
ALTER USER ‘username’@‘localhost’ IDENTIFIED BY ‘12345678’ password expire interval 30 day ;
// 查询用户最后修改密码的时间及密码过期策略信息;
select user,host,password_expired,password_last_changed,password_lifetime from mysql.user;
用户锁定
ALTER USER ‘username’@‘localhost’ ACCOUNT LOCK; - - 用户锁定
ALTER USER ‘use