Assume the following have completed:
GRANT ALL ON test1.* TO 'johnQ'@'localhost' IDENTIFIED BY 'pass1'; GRANT ALL ON test2.* TO 'johnQ'@'localhost' IDENTIFIED BY 'pass2';
User johnQ has a query that joins tables from test1 to tables from test2. How should he log in?
a) Using ‘pass1’.
b) Using ‘pass2’.
c) Using ‘pass1’ and ‘pass2’, separated by a colon.
d) It can’t be done; he must change the two passwords to match.
e) Other (explain)
Show Answer ▼