First, nice username :) Anyhow, use the /etc/init.d/mysqld script as root to start/stop mysql, not the safe_mysqld binary. The init.d script really calls the safe_mysqld binary, but ti also makes a couple sanity checks like ensuring that the initial database files exist and are owned by the proper user. Example: # /etc/init.d/mysqld start
This should get you past the problem you are currently having, which is that mysqld can't find it's database files. This is mostly due to redhat's mysql rpm installing the database files in a different location than mysql's distibution does. Hope this helps, Ryan Fox [EMAIL PROTECTED] On Thu, 2002-07-18 at 11:44, Richard Fox wrote: > The mysqld.log file says: > > 020717 13:05:05 mysqld started > 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file: > './mysql/host.frm' (errno: 13) > 020717 13:05:05 mysqld ended > > But I do see the host.frm file: > > -rw-rw---- 1 root root 8958 Jul 17 13:04 > /var/lib/mysql/mysql/host.frm > > How did you fix this problem? > > I do have the /var/lib/mysql/mysql.sock file... > > Thanks > Rich > > > I'm near enough in the same position as you are. Check the file > > /var/log/mysqld.log to see what the problem is. I had a problem accessing > > the file './mysql/host.frm', but I think that I've fixed this now. > > > > What happens when you try the 'mysql' command? I get the response > > "can't connect to local MySQL server through socket > > '/var/usr/mysql/mysql.sock'" > > And indeed there is no such file. > > Do you have this file? > > > > -----Original Message----- > > From: Richard Fox [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, July 17, 2002 10:41 PM > > To: [EMAIL PROTECTED] > > Subject: MySQL: Problem Installing on RH 7.3 > > > > > > > > The MySQL daemon does not run. I installed the binary RPM's from the RH > cd, > > MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to > > execute correctly. The I run safe_mysqld &, and I get: > > > > [root@thor rfox]# /usr/bin/safe_mysqld & > > [1] 2212 > > [root@thor rfox]# Starting mysqld daemon with databases from > /var/lib/mysql > > 020717 15:21:28 mysqld ended > > > > That's it! I tried both the rpm and compiling it myself from source with > > BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior > > > > I just need a little hint, please! How do I troubleshoot this? > > > > Thanks, > > > > Rich > > > > sql > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
