"Carson J. Reynolds" wrote:
>
> I've managed to get mysql compiled and installed on my Redhat6.0 box.
> However, I can only seem to get mysql to load by putting lines in the
> /etc/rc.local file. I've traced this back to faulty execution of
> mysql.server. "mysql.server stop" works like a charm. However, when I try
> to call "mysql.server start" it immediately exits:
>
> [root@arsenal mysql]# mysql.server stop
> Killing mysqld with pid 592
> [root@arsenal mysql]# mysql.server start
> [root@arsenal mysql]# Starting mysqld daemon with databases from
> /usr/local/var/mysql
> mysqld daemon ended
>
> my (localhost).err file only has the following:
>
> 990708 10:45:59 /usr/local/libexec/mysqld: Normal shutdown
>
> 990708 10:45:59 /usr/local/libexec/mysqld: Shutdown Complete
>
> mysqld ended on Thu Jul 8 10:45:59 EDT 1999
> mysqld started on Thu Jul 8 10:46:03 EDT 1999
> 990708 10:46:03 /usr/local/libexec/mysqld: Table 'mysql.host' \
> doesn't exist
> mysqld ended on Thu Jul 8 10:46:03 EDT 1999
>
> That's sort of odd, because when I start with safe_mysqld I can go in
> "SELECT * FROM host" after telling mysql to "use mysql".
>
> Anyone have any thoughts on this? The RPM install had the exact symptoms,
> so I decided to go with source (which I perfer), but I can't seem to shake
> this problem. I have gone in and verified that PATH, bindir, datadir,
> pid_file, and mysql_daemon_user are all correct. I'm unsure about what
> basedir I should use. Is the problem that I haven't put together a my.cnf
> file?
>
> -carson-
>
What is the output of /usr/local/libexec/mysqld --help ?
Can you post the source of mysql.server ?
--
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)