020221 13:12:19 mysqld started
020221 13:12:20 /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
020221 13:12:20 mysqld ended
also it would be important to note /etc/my.cnf
ahh could be a permission problem, the directories require an executable tag
drw-rw---- 2 mysql mysql 512 Jan 18 18:51 mysql
-rw-rw---- 1 mysql mysql 0 Jan 18 18:45 host.MYD
-rw-rw---- 1 mysql mysql 1024 Jan 18 18:45 host.MYI
-rw-rw---- 1 mysql mysql 8958 Jan 18 18:45 host.frm
From: Dan Nelson [mailto:dnelson@stripped]
Sent: Thursday, February 21, 2002 1:46 PM
To: Luc Foisy
Cc: MYSQL-List (E-mail)
Subject: Re: Problems finding parts of mysql on FreeBSD
In the last episode (Feb 21), Luc Foisy said:
> Ok. I do indeed have /usr/local/etc/rc.d/mysql-server.sh
> And oops I do have /usr/local/libexec/mysqld
> Are these supposed to be started up automatically?
> I tried to run /usr/local/etc/rc.d/mysql-server.sh start
> TMCBSD101# mysql-server.sh start
> mysql-server.sh: Command not found.
> TMCBSD101# ./mysql-server.sh start
> TMCBSD101# ps -ax
> TMCBSD101# mysql
> ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (61)
Take a look at /var/db/mysql/<hostname>.log and <hostname>.err; it
looks like mysql might have exited immediately after it was started.
> /usr/local/bin/safe_mysqld & -user=mysql > /dev/null
> will load the mysql server. So why is this not performed at start up?
> And if this script is used, what is mysqld used for??
safe_mysqld calls mysqld and loops so that if mysqld died unexpectedly
it is restarted.