Bug #6264 mysql.proc error
Submitted: 26 Oct 2004 14:56 Modified: 1 Nov 2004 21:32
Reporter: wang wei Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.0.0-alpha OS:Windows (windows 2000 professional)
Assigned to: Sergei Golubchik CPU Architecture:Any

[26 Oct 2004 14:56] wang wei
Description:
when I was create a table like this ,but the mysql doesn't work,

mysql> create table jokes(
    -> id int not null auto_increment primary key,
    -> jokeText TExt,
    -> jokeDate DATE not null
    -> );

ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist

How to repeat:
mysql> create table jokes(
    -> id int not null auto_increment primary key,
    -> jokeText TExt,
    -> jokeDate DATE not null
    -> );

ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
[26 Oct 2004 15:23] MySQL Verification Team
i wasn't able to repeat:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.0-alpha-nt-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table jokes(
    -> id int not null auto_increment primary key,
    -> jokeText TExt,
    -> jokeDate DATE not null
    -> );
Query OK, 0 rows affected (0.16 sec)

mysql>
[1 Nov 2004 16:16] MySQL Verification Team
When you installed 5.0.0-alpha was an upgrade ?.
If yes then the grant tables were not wrote in
your install directory and the error reported
happens.

Thanks
[1 Nov 2004 21:32] Sergei Golubchik
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

This bug is already fixed in 5.0.1.
Please upgrade.

(or run mysql_fix_privilege_tables to create missing mysql.proc table, which will help too.
But if you hit another bug in 5.0.0 which was fixed in 5.0.1 - and there are *many* - you'll have to upgrade anyway)