Sorry, I should have given more details. Its Mysql 4.1 alpha on a Suse Linux system Version 8.1.
...and yes, the mysql.host table and the other 5 exist and are well alive ;-). If I replace my.cnf with a version skipping innodb then it perfectly starts up, so it must be related to innodb, perhaps my.cnf and/or mysql itself. Best regards Nils Valentin 2003年 6月 4日 水曜日 12:36、Nils Valentin さんは書きました: > Hi Mysql list members, > > I added a Innodb database to the existing MyISAM databases and now MySQL > doesnt start up. From the InnoDB logfile I saw this error message > > Can't open privilege tables: Table 'mysql.host' doesn't exist > > > Does any body know what this error comes from ? > > innodb logfile extract. > > 030603 16:46:20 InnoDB: Log file ./ib_logfile0 did not exist: new to be > created > InnoDB: Setting log file ./ib_logfile0 size to 80 MB > InnoDB: Database physically writes the file full: wait... > 030603 16:46:31 InnoDB: Log file ./ib_logfile1 did not exist: new to be > created > InnoDB: Setting log file ./ib_logfile1 size to 80 MB > InnoDB: Database physically writes the file full: wait... > InnoDB: Doublewrite buffer not found: creating new > InnoDB: Doublewrite buffer created > InnoDB: Creating foreign key constraint system tables > InnoDB: Foreign key constraint system tables created > 030603 16:46:48 InnoDB: Started > 030603 16:46:49 Fatal error: Can't open privilege tables: Table > 'mysql.host' doesn't exist > 030603 16:46:49 mysqld ended > > ..... > > > 030604 09:30:28 mysqld started > 030604 9:30:47 InnoDB: Database was not shut down normally. > InnoDB: Starting recovery from log files... > InnoDB: Starting log scan based on checkpoint at > InnoDB: log sequence number 0 43892 > InnoDB: Doing recovery: scanned up to log sequence number 0 43892 > 030604 9:30:48 InnoDB: Flushing modified pages from the buffer pool... > 030604 9:30:49 InnoDB: Started > 030604 9:30:49 Fatal error: Can't open privilege tables: Table > 'mysql.host' doesn't exist > 030604 09:30:49 mysqld ended > > Any reply much appreciated. > > -- > ================================================ > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp > ================================================ -- ================================================ Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp ================================================ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
