List:General Discussion« Previous MessageNext Message »
From:Egor Egorov Date:January 28 2004 2:47pm
Subject:Re: Innodb firsttime startup error
View as plain text  
"Kev" <karigna@stripped> wrote:
> I just ran mysql 4.0.15 on a Mac for the first time and got the following in
> my .err file:
>
>
> 
> InnoDB: a new database to be created!
> 040128  7:40:24  InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full: wait...
> 040128  7:40:25  InnoDB: Log file ./ib_logfile0 did not exist: new to be
> created
> InnoDB: Setting log file ./ib_logfile0 size to 20 MB
> InnoDB: Database physically writes the file full: wait...
> 040128  7:40:45  InnoDB: Log file ./ib_logfile1 did not exist: new to be
> created
> InnoDB: Setting log file ./ib_logfile1 size to 20 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
> 040128  7:41:08  InnoDB: Started
> 040128  7:41:08  Fatal error: Can't open privilege tables: Table
> 'mysql.host' doesn't exist
> 040128  7:41:08  Aborting
>
> 040128  7:41:08  InnoDB: Starting shutdown...
> 040128  7:41:11  InnoDB: Shutdown completed
> 040128  7:41:11  /Library/MySQL/libexec/mysqld: Shutdown Complete
>
> 040128 07:41:11  mysqld ended

This error isn't related to the InnoDB. It means that you doesn't have privilege tables or
MySQL doesn't have permission on the data dir.
Check if privilege table files exist in the directory of the database mysql. If so, check
permissions on the files and data dir. 
If files don't exist, you should run mysql_install_db script to install grant tables.

 

How do I create the mysql.host file and where should it be located?




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com



Thread
Innodb firsttime startup errorKev28 Jan
  • Re: Innodb firsttime startup errorEgor Egorov28 Jan