050116 12:51:32 mysqld ended, Plese Help :(

[x0054]

Hay guys, I have been scratching my head about this for some time, well 2 days, but my site is down and I need to fix it soon.

When starting mySQL (I run it on Slackware 10.0) after few seconds it ends and prints out a message: 050116 12:51:32 mysqld ended

I looked in the error logs. Here is what I found:

050116 12:51:29 mysqld started
050116 12:51:30 InnoDB: Started
050116 12:51:30 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
050116 12:51:30 Aborting

050116 12:51:30 InnoDB: Starting shutdown...
050116 12:51:32 InnoDB: Shutdown completed
050116 12:51:32 /usr/libexec/mysqld: Shutdown Complete

050116 12:51:32 mysqld ended

I gather that the problem is with the mysql.host file. Problam is, I have no idea what to do about that? Please help,

- Bogdan

[sarumont]

Obviously, the priveledge table doesn't exist. You'll have to treat it as if you've never had it running. I think this can be done by running the 'mysql_install_db' script, but I'm not sure on that.

[puntmuts]

su - mysql    <-- mind the - in the command 
mysql_install_db
exit

Follow the instructions on your screen to set a root password for mysql.
Done

[x0054]

Thank you, that fixed the problem. Wow, I guess am never going back to Win Servers Again

- Bogdan