mysql 4.0.20 dies on start

[thonot]

When I start mysql usin /etc/init.d/mysql start
I get no errors

Code: Select all

skids thonot # /etc/init.d/mysql start
 * Starting mysqld...                                                                  [ ok ]
skids thonot #

But when I try to connect I get errors:

Code: Select all

skids thonot # mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

And when I check /var/log/mysql/mysqld.err, it shows the following:

Code: Select all

040716 15:11:40  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
040716 15:11:40  Aborting

040716 15:11:40  /usr/sbin/mysqld: Shutdown Complete

I also noticed that the directory: /var/lib/mysql/mysql is empty.

[vla_do]

Code: Select all

skids thonot # /usr/bin/mysql_install_db

[thonot]

Cool!
Thanks!

[LodBot]

Code: Select all

skids thonot # /usr/bin/mysql_install_db

I'm having the same exact problem and that didn't help. Any other ideas?

Thanks.