You inherit a legacy database system when the previous DBA, Bob, leaves the company.
You are notified that users are getting the following error: mysql> CALL film_in_stock (40, 2,
@count); ERROR 1449 (HY000): The user specified as a definer (‘bon’@’localhost’) does
not exist How would you identify all stored procedures that pose the same problem?
A.
Execute SHOW ROUTINES WHERE DEFINER=’bob@localhost’.
B.
Execute SELECT * FROM INFORMATION_SCHEMA. ROUTINES WHERE
DEFINER=’bob@localhost’;.
C.
Execute SELECT * FROM INFORMATION_SCHEMA. PROCESSLIST WHERE
USER=’bob’ and HOST=’ localhost’;.
D.
Examine the Mysql error log for other ERROR 1449 messages.
E.
Execute SELECT * FROM mysql.routines WHERE DEFINER=’bob@localhost’;.
B
B