JZTXT

mysql锁账号

发布时间 2023-08-17 09:29:31作者: slnngk

mysql锁账号
mysql 8.0.28
ALTER USER 'hxl'@'%' ACCOUNT LOCK;
ALTER USER 'hxl'@'%' ACCOUNT UNLOCK;

 

mysql7锁账号与mysql8一致
ALTER USER 'mytest'@'%' ACCOUNT LOCK;
ALTER USER 'mytest'@'%' ACCOUNT UNLOCK;