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 SELECT * FROM mysql.routines WHERE DEFINER=’bob@localhost’;.
B.
Execute SHOW ROUTINES WHERE DEFINER=’bob@localhost’.
C.
Execute SELECT * FROM INFORMATION_SCHEMA. ROUTINES WHERE
DEFINER=’bob@localhost’;.
D.
Execute SELECT * FROM INFORMATION_SCHEMA. PROCESSLIST WHERE USER=’bob’
and HOST=’ localhost’;.
E.
Examine the Mysql error log for other ERROR 1449 messages.