(5.7)
select user,host, account_locked from mysql.user;
alter user user10 account lock;
alter user user10 account unlock;
(12cR1)
select username,account_status from dba_users order by username;
alter user user10 account lock;
alter user user10 account unlock;
(9.4)
\du
alter user user10 nologin;
alter user user10 login;
(2014)
select name,is_disabled from sys.server_principals;
alter login user10 disable;
alter login user10 enable;