mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) mysql> show create procedure year_on_job \G ERROR 1305 (42000): PROCEDURE year_on_job does not exist mysql> show create procedure year_on_job\G

The correct syntax for showing the create statement of a stored procedure is:

SHOW CREATE PROCEDURE procedure_name;

So in this case, the correct command to show the create statement of the "year_on_job" stored procedure would be:

SHOW CREATE PROCEDURE year_on_job\G

Note that the "\G" at the end is optional, and is used to display the output in a vertical format.