Bug #14623 create procedure results in missing 'mysql.proc' table
Submitted: 4 Nov 2005 2:33 Modified: 4 Dec 2005 3:12
Reporter: Alice Tong Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.15-nt-log OS:Windows (Windows XP Professional SP2)
Assigned to: Assigned Account CPU Architecture:Any

[4 Nov 2005 2:33] Alice Tong 
Description:
I just installed 5.0 and was trying out the example in the mySQL manual for procedures and kept on getting the same 'mysql.proc' doesn't exist error:

mysql> delimiter //
mysql> create procedure simpleproc (out param1 int)
    -> begin
    -> select count(*) into param1 from irp_2004_vehicle;
    -> end
    -> //
ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist

How to repeat:
mysql> delimiter //
mysql> create procedure simpleproc (out param1 int)
    -> begin
    -> select count(*) into param1 from irp_2004_vehicle;
    -> end
    -> //
[4 Nov 2005 3:12] MySQL Verification Team 
Looks to me that the 5.0.15 installer not installed the grant tables
(mysql database) leaving intact the older 4.1.XX. Please apply
the process recommended for to upgrade mentioned at:

http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html

Thanks in advance.
[5 Dec 2005 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".