MySQL Startup Problem

[dcomit]

I’ve installed mysql-5.0.45 on Solaris 8 using pkgadd:

pkgadd –d /tmp/mysql-5.0.45-solaris8-sparc-64bit.pkg –R /export/home

Because I installed to a non standard directory, I had to create directories in /export/home/usr for the symbolic links to be created, otherwise the installation failed.

After successful installation I tried to start the mysql daemon but it errored. Here is the error log.
[tt]
080111 09:39:22 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
080111 9:39:22 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080111 9:39:22 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...
080111 9:39:22 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
080111 9:39:23 InnoDB: Started; log sequence number 0 0
080111 9:39:23 [ERROR] Fatal error: Can't open and lock privilege tables: Table
'mysql.host' doesn't exist
080111 09:39:23 mysqld ended[/tt]

How can I create the mysql.host table if I can't start the daemon?

Any ideas welcome.

Dave

 

[Kozusnik]

Seems like a rights issue. Is the user who "owns" the file and directory the same as the user running the daemon?

Mark