Nils, ----- Original Message ----- From: ""Nils Valentin"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, June 04, 2003 7:05 AM Subject: Re: Can't open privilege tables: Table 'mysql.host' doesn't exist
> Sorry, I should have given more details.=20 > Its Mysql 4.1 alpha on a Suse Linux system Version 8.1. > > =2E..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= > =20 > up, so it must be related to innodb, perhaps my.cnf and/or mysql itself. the problem is in your my.cnf or the access rights of the person running mysqld. The error means mysqld cannot access the file host.frm in the mysql subdir under the datadir. I suggest specifying the datadir explicitly in your my.cnf. > Best regards > > Nils Valentin Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ > > 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. > > > > -- > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > > Valentin Nils > > Internet Technology > > > > E-Mail: [EMAIL PROTECTED] > > URL: http://www.knowd.co.jp > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > > =2D-=20 > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
