Help starting mysql.

[Mike Wright]

Reg Clemens wrote:
> When I do a
>         mysqld start
> (from /etc/rc.d/init.d), there is a long pause, mabe a minute, and then
> the message
>            Starting MySQL:                                            [FAILED]
> 
> The first time I tried starting mysql, I saw in the mysql.log file the 
> following messages
> 
> ---
> 
> 081028 14:41:25  mysqld started
> InnoDB: The first specified data file ./ibdata1 did not exist:
> InnoDB: a new database to be created!
> 081028 14:41:25  InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full: wait...
> 081028 14:41:25  InnoDB: Log file ./ib_logfile0 did not exist: new to be 
> created
> InnoDB: Setting log file ./ib_logfile0 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> 081028 14:41:25  InnoDB: Log file ./ib_logfile1 did not exist: new to be 
> created
> InnoDB: Setting log file ./ib_logfile1 size to 5 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
> 081028 14:41:26  InnoDB: Started; log sequence number 0 0
> 081028 14:41:26 [ERROR] Fatal error: Can't open and lock privilege tables: 
> Table 'mysql.host' doesn't exist
> 081028 14:41:26  mysqld ended

The database management tables need to be created/initialized.

Try "mysql_install_db".  After that you should be good to go.

hth, :m)