An employee cannot access the company database. You check the connection variables:
Mysql> SHOW GLOBAL VARIABLES LIKE ‘%connect%’;
8 rows in set (0.00 sec)
A look at the user privileges shows:
GRANT… TO ‘bob’@’%, example.com’ WITH MAX_USER_CONNECTIONS 0;
GRANT… TO ‘key’@’%, example.com’ WITH MAX_USER_CONNECTIONS 1;
GRANT… TO ‘joe’@’%, example.com’ WITH MAX_USER_CONNECTIONS 50;
What is a valid explanation for why one of the users is unable to connect to the database?
A.
Bob has max_user_connections set to zero, which blocks all his connections
B.
Joe has exceeded the max_user_connections global limit.
C.
All users are blocked because max_user_connections is accumulated over the host account
information.
D.
Kay is already connected elsewhere and attempting to log in again.
E.
Connect_timeout is too small to allow a connection to occur.
Explanation:
A is not true.I think D is true.
D should be true.
D.
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_max_user_connections
D absolutely
I think D
D
A: false, zero is the default and means no-limits,
B: false, should have stated “jon has consumed all the max_user_connections limits” thus falling under `D` case.
C: false, root can connect even if max_user_connections is reached
D: true, kay is already connected and can’t login again
E: false, connection timeout is not related