[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: Help starting mysql.



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)


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]