Examine Joe's account:
CREATE USER 'joe'@'%' IDENTIFIED BY '*secret*'
GRANT ALL PRIVILEGES ON *.* TO 'joe'@'%'
All existing connections for joe are killed.
Which two commands will stop joe establishing access to the MySQL instance? (Choose two.)
Examine Joe's account:
CREATE USER 'joe'@'%' IDENTIFIED BY '*secret*'
GRANT ALL PRIVILEGES ON *.* TO 'joe'@'%'
All existing connections for joe are killed.
Which two commands will stop joe establishing access to the MySQL instance? (Choose two.)
To stop Joe from establishing access to the MySQL instance, two effective commands are ALTER USER 'joe'@'%' ACCOUNT LOCK and ALTER USER 'joe'@'%' SET password='*invalid*'. Locking the account prevents any login attempts, while setting an invalid password ensures that Joe cannot log in even if he tries. REVOKE commands only affect privileges, not the ability to connect to the MySQL instance.
I think A and B
AE, with C he can still connect.