MySQL Bugs: #24022: Can't select from information

Bug #24022	Can't select from information_schema.events
Submitted:	6 Nov 2006 18:52	Modified:	1 Dec 2006 21:31
Reporter:	Jan Bielawski	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Packaging	Severity:	S3 (Non-critical)
Version:	5.1.12-beta	OS:	Windows (win xp pro)
Assigned to:	Kent Boortz	CPU Architecture:	Any
Tags:	information_schema.events

Description:
It isn't possibly to select anything from the "information_schema.events" table.
Instead you will get the following error from your client program.

E.g.
mysql> select * from information_schema.events;
ERROR 1146 (42S02): Table 'mysql.event' doesn't exist

From: 5.1.12-beta-community-nt MySQL Community Server (GPL)

How to repeat:
mysql> select * from information_schema.events;

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

Thank you for your report. Do you have mysql.event table? Is this a new installation or you have upgraded from a previous version?

Thank you!

Probably this is an upgrade/installation issue:

C:\dbs\5.1\bin>mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.12-beta-community-nt MySQL Community Server (GPL)

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

mysql> select * from information_schema.events;
Empty set (0.06 sec)

After the use of the provided sql-script "mysql_fix_privilege_tables.sql" the problem had vanished.

I have done a completly new installation, so I thought applying that script should not be nessessary.

My be that is a kind packaging issue?

J. Bielawski.

Thank you for the feedback.
http://dev.mysql.com/doc/refman/5.1/en/mysql-fix-privilege-tables.html
It is a procedure to be performed when upgrading according the versions
involved.

Sorry I misundertood you about an upgrade not a fresh full install,
indeed it is a packing issue and the noinstall package doesn't
presents this issue:

C:\dbs\5.1\bin>mysql -uroot -p --port=3308
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.12-beta-community-nt MySQL Community Server (GPL)

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

mysql> select * from information_schema.events;
ERROR 1146 (42S02): Table 'mysql.event' doesn't exist
mysql>

Bug #24425 was marked as a duplicate of this one.

The problem will be fixed in 5.1.13 to be released soon. In the meanwhile you can use the event.frm, event.MYD and event.MYI from the ZIP package.

Thank you for trying 5.1.12-beta!

The WiX installer specification is updated,
the missing tables will be in 5.1.14.