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.)
A.
ALTER USER 'joe'@'%' ACCOUNT LOCK
B.
ALTER USER 'joe'@'%' SET password='*invalid*'
C.
REVOKE ALL PRIVILEGES ON *.* FROM 'joe'@'%'
D.
ALTER USER 'joe'@'%' PASSWORD HISTORY 0
E.
ALTER USER 'joe'@'%' IDENTIFIED BY '*invalid*' PASSWORD EXPIRE
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
eena96
6 months, 1 week agomarklv
11 months, 1 week ago