Bug #6264 mysql.proc error

• Submitted: 26 Oct 2004 14:56
• Modified: 1 Nov 2004 21:32
• Reporter: wang wei
• Status: Closed
• 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)