General
cancel
Showing results for 
Search instead for 
Did you mean: 

mySQL failed to start on HP11.11 node

GPS
Advisor

mySQL failed to start on HP11.11 node

I have a HP B1000 node. I have mySQL version "mysql-standard-5.0.18-hpux11.00-hppa2.0w-64bit" installed.

During the installation, there is no error.

But when starting mySQL, I got following errors:

nodename:root> Starting mysqld daemon with databases from /usr/local/mysql-standard/all/usr/local/mysql-standard-5.0.18-hpux11.00-hppa2.0w-64bit/mysql/data
STOPPING server from pid file /usr/local/mysql-standard/all/usr/local/mysql-standard-5.0.18-hpux11.00-hppa2.0w-64bit/mysql/data/.pid
060131 10:58:26 mysqld ended

I checked the log .err

/usr/local/mysql-standard/all/usr/local/mysql-standard-5.0.18-hpux11.00-hppa2.0w-64bit/mysql/data

I got following log.
===========================================================
060131 11:12:04 mysqld started
060131 11:12:05 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
060131 11:12:05 mysqld ended
======================================================

I am not sure it is HP specific issue.

Anyone has mySQL installed on HP11.11 can share your points? Thanks
3 REPLIES
Eric Antunes
Honored Contributor

Re: mySQL failed to start on HP11.11 node

Hi GPS,

I don't understand nothing about mySQL but this error is normally a permission issue. You must give to the mySQL database owner Unix user the rwx to the directory(ies) where the datafiles and other necessary directories.

Regards,

Eric Antunes
Each and every day is a good day to learn.
GPS
Advisor

Re: mySQL failed to start on HP11.11 node

Thanks for the reply.
Based on previous log, it was somewhat related to permission. So I set all the direcotries to 777. Now things are better, but starting mySQL still failed.

What is "mysql.host" about?

===========================================================
060131 12:45:11 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
060131 12:45:12 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060131 12:45:12 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...
060131 12:45:13 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
060131 12:45:14 InnoDB: Started; log sequence number 0 0
060131 12:45:14 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
060131 12:45:14 mysqld ended

==========================================================
Eric Antunes
Honored Contributor

Re: mySQL failed to start on HP11.11 node

Hi again,

Check this doc:

http://dev.mysql.com/doc/refman/5.0/en/cannot-find-table.html

Best Regards,

Eric Antunes
Each and every day is a good day to learn.