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: | |
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
[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)