PDA

View Full Version : MySQL: Starting mysqld


JohnB
28th January 2005, 04:14 PM
If safe_mysqld doesn't seem to work, try these options:

# safe_mysqld --basedir=/usr --user=root

There are many FedoraForum posts with similar problems, leading to issues with SELinux, RPM installation order, and other complex problems; but if you are getting messages like "can't find host.frm" even though you've run mysql_install_db (which you should), try this, it worked for me.

This was a "straighforward" installation of FC3 and MySQL 3.23 from the FC3 binary CDROM set. Yes, I know MySQL 4 is much better, but first things first.

Any comments as to why this works would be appreciated; I assume that the RPMs installed the various files in places that the safe_mysqld script doesn't expect. I don't know why, but the user=root option seems necessary. I found these by experimenting with the mysqld daemon invocation directly, then observed that safe_mysqld will pass the options on to mysqld.

I haven't gone much further yet, but now mysql is running and I can run the mysql client (as root or ordinary user) and see the supervisory databases that mysql_install_db created.

tk
28th January 2005, 04:21 PM
hmm here I just do a '/etc/rc.d/init.d/mysql restart' which always worked on all redhats/fedoras so far since these startup scripts usually have all these options set correctly.

Tashiro
28th January 2005, 04:28 PM

Moved to servers.

Tashiro