MySQL Bugs: #42100: Incorrect definition of table mysql.event

Bug #42100	Incorrect definition of table mysql.event
Submitted:	14 Jan 2009 9:19	Modified:	14 Feb 2009 11:00
Reporter:	christian salome	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.1.30	OS:	Windows (xp pro sp3)
Assigned to:		CPU Architecture:	Any
Tags:	Can't open and lock privilege tables

Description:
I am testing wamp 2.0 and easyphp 3 and i encounter the following problem only with wamp (from log file):
________________________________________________________________________________
090114  9:49:06  InnoDB: Started; log sequence number 0 46409
090114  9:49:06 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
090114  9:49:06 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_Z
090114  9:49:06 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
090114  9:49:06 [Note] wampmysqld: ready for connections.
Version: '5.1.30-community-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
____________________________________________________________________________
Best Regards.

How to repeat:
every time

Thank you for the report.

Did you upgrade MySQL server? Did you run mysql_upgrade if so?

Hello,
No, i did neither upgrade MySQL server nor  run mysql_upgrade.
I got that error immediately after installing wamp 2.0.

Cordially.

Thank you for the feedback.

This can be problem of wamp package which we don't support. Please try our binaries available at http://dev.mysql.com/downloads and inform us if problem exists with them as well.

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".