MySQL failing to start due to 'mysql.host' doesn't exist

[bobby76]

Hi

I have tried to install MySQL 5.0.45 on to Solaris 8. The initial install did not go smoothly as the OS was not patched properly and prevented the grant tables from being automatically installed. After patching the grant tables required installing & all went fine.
Time to start MySQL:
# bin/mysqld_safe --user=mysql &
1619
# Starting mysqld daemon with databases from /opt/mysql/mysql/data
STOPPING server from pid file /opt/mysql/mysql/data/sunweb1.pid
071026 10:31:21 mysqld ended
# bin/mysqladmin version
bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

Checking the error log:

# tail sunweb1.err
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
071026 10:31:20 InnoDB: Started; log sequence number 0 0
071026 10:31:20 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
071026 10:31:21 mysqld ended

Further searching did indeed result in confirmation that the mysql.host does not exist so its not an ownership or permissions problem.

Any suggestions?

Many thanks

 

[DonQuichote]

If you cannot connect to "localhost" (which means that a socket is used on unix-like systems), you can connect to 127.0.0.1, to specifically use tcp. look in the man pages or help for the command-line options.