Nils, most probably you have some other difference in the my.cnf files.
Regards, Heikki ----- Original Message ----- From: "Nils Valentin" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, June 04, 2003 6:22 PM Subject: Re: Can't open privilege tables: Table 'mysql.host' doesn't exist Hi Heikki, Thank you for the reply. I understand that this is related to the host.frm. Thank you very much. The part which I don't get is why would a standard my.cnf file (skipping innodb) start up and the my.cnf file containing the innodb settings give me such an error ? I understood your advice and I am in process of repairing this, however I would really appreciate if I could also technically understand why this is. This case I can learn and step up ;-) Do you mind explaining why this is ? Best regards Nils Valentin 2003年 6月 4日 水曜日 21:09、Heikki Tuuri さんは書きました: > 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] -- ================================================ 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]
