mySQL failed to start on HP11.11 node

[GPS]

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

[Eric Antunes]

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

[GPS]

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]

Hi again,

Check this doc:

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

Best Regards,

Eric Antunes