"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
> 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
What is the output of /usr/local/libexec/mysqld --help ?
Can you post the source of mysql.server ?