IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    MySQL 5.6 Database Administrator-003-How would you identify all stored procedures that pose the same problem?

    royalwzy发表于 2015-09-01 23:13:15
    love 0
    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.


沪ICP备19023445号-2号
友情链接