mysql查询所有用户及删除用户

查询用户

select user, host, password_expired from mysql.user;

删除用户

DROP USER '[username]'@'localhost' ；

刷新权限

FLUSH PRIVILEGES；

查询所有用户/账号设置/日志/开启日志

select user,host,password_expired,password_last_changed,password_lifetime from mysql.user  ; 

select user,host,account_locked from user; show global variables like '%general%';  

SET GLOBAL general_log = 'ON';

查询用户密码

select user,authentication_string from mysql.user;       

查询密码复杂度

show variables like 'validate_password%';

密码有效期

select user,password_expired from mysql.user where user='permission_user' ;

超时时间、ssl

show variables like '%timeout%';   
show variables like '%have_ssl%'; 
show variables like '%have_openssl%';