Disable All Logins

[David Paskiet]

I have upgraded to MySQL 5.7 and know that I can 'lockout' an account. I am having difficulties however accomplishing this task automatically. I need for a process to run completely before any user can log in. If they log in the process wil fail. So simplistically here is the need.

1. Kill all user connections sans root, backup, me
ALTER USER <user>@<host> ACCOUNT LOCK;
2. Lockout all users same as above
3. Run Process
4. Enable all users locked out in step 2.
ALTER USER <user>@<host> ACCOUNT LOCK;

Any help I could get here would be great. I am an experienced SQL Server developer and dba who is semi new to MySQL and am struggling a bit for these seemingly simple tasks.