MySQL 4.x runs until server reboot

[cvia7503]

I just recently migrated a Windows 2003 Server (Apache 2.0.50, PHP 5, and MySQL 4) to Fedora Core 2 and everything worked like a charm for 5 consecutive days, and then I had to reboot. On startup, apachectl start carried out just fine, but mysqld_safe --user=mysql tried to start the MySQL server and immediately ended.

I did a netstat -atop and then killed the mysqld process id as well as going into the process manager gui and killing the mysqld_safe that failed.

I have removed and recompiled and installed mysql again with the same issue. Is anyone else having this issue? What did YOU do?

[jasonlambert]

You need to look in your "<hostname>.err" file (normally in the mysql DATA directory), to see WHY mysqld failed to start - then fix the problem.

Something that is confusing is your talking about it not starting, then your talking about having to go kill a process? If it failed to start there wouldnt be any processes running.

Lastly, take at look at this page which i've always found to be helpful in the past:
http://dev.mysql.com/doc/mysql/en/Starting_server.html

J

[cvia7503]

This is command line:

[root@HDTEST bin]# ./mysqld_safe --user=mysql
Starting mysqld daemon with databases from /usr/local/mysql/var
040907 16:00:22  mysqld ended

[root@HDTEST bin]#

This is the error log thereafter:

040907 16:00:20  mysqld started
040907 16:00:20  InnoDB: Started
040907 16:00:20  Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040907 16:00:20  Aborting

040907 16:00:20  InnoDB: Starting shutdown...
040907 16:00:22  InnoDB: Shutdown completed
040907 16:00:22  /usr/local/mysql/libexec/mysqld: Shutdown Complete

040907 16:00:22  mysqld ended

[jasonlambert]

040907 16:00:20  Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)

If your error log file has something like:

Can't find file: './mysql/host.frm' (errno: 13)

, and you've tried setting
--datadir=/path/to/my/data/directory but you
still get the same error, it may be because the
databases installed in the mysql data directory
(usually /var/lib/mysql) are not owned by the
mysql daemon, but by the user who ran
mysql_install_db. chown them to mysql and chgrp
them to the appropriate group e.g.

chown -R mysql /var/lib/mysql/mysql
chgrp -R daemons /var/lib/mysql/mysql

Try starting mysqld like:

cd /usr/local/mysql
./bin/safe_mysqld --user=mysql --datadir=/path/to/mysql/data