Does phpmyadmin support lock/unlock db user feature on web?

[thaygiaoth]

Steps to reproduce

1. I using phpmyadmin 4.8.0.1 latest but I can not find out lock/unlock user on phpmyadmin?
2. Does phpmyadmin support lock/unlock db user feature on web?

Expected behaviour

There are lock/unlock buttons for every db user (except root) on phpmyadmin
As of version 5.7.6, MySQL supports locking and unlocking user accounts
https://dev.mysql.com/doc/refman/5.7/en/account-locking.html

[ibennetch]

You're correct that this is not supported, but seems like a pretty straightforward project to add a toggle to the User accounts area.

I think a robust solution would verify the existence of the account_locked column in the mysql.user table when attempting to make a change, and perhaps also if this column is missing the display would show all users enabled but greyed out.

[thaygiaoth]

Updates for MariaDB 10.4.1

mysql.user table is retired. User accounts and global privileges are now stored in the mysql.global_priv table (MDEV-17658)

https://mariadb.com/kb/en/library/mariadb-1041-release-notes/