Choose two.
Examine this statement, which executes successfully:
CREATE USER mary@192.0.2.100 IDENTIFIED BY ‘P@SSw0rd‘ REQUIRE NONE PASSWORD EXPIRE;
Which two are true?
AMary must connect using the username ‘mary@192.0.2.100‘.
BMary requires no password to connect to the MySQL server.
CMary must connect from the client machine 192.0.2.100.
DMary cannot connect to the MySQL server until the DBA resets her password.
EMary cannot query data until she changes her password.