----- Original Message -----
From: "Joseph Greenawalt" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 8:05
Subject: Ignore the previous read this one: Help! Can't get server running.
Fresh installs RedHat and Mysql RPM
> Hello all, I hope someone can help. I have a fresh install of Red Hat
> 7.0, I installed mysql-3.23.22-6.i386.rpm and then
> mysql-server-3.23.22-6.i386.rpm. Supposedly the daemon is automatically
> starts, well it doesn't. I tried the mysql_install_db and it runs, but
> I don't think it makes the databases because when I try to start the
> daemon with safe_mysqld & it says it tries to open the databases in
> /var/lib/mysql, shouldn't there be a data directory or something? Here is
> what happens when I run it:
> [root@localhost mysql]# Starting mysqld daemon with databases from
> /var/lib/mysql
> 010307 19:49:49 mysqld ended
I'm surprised you said it doesn't start automatically as the message above
usually indicates that it has already started. Did your try "ps -ef | grep
mysql" to find out for sure? Or did I misunderstand you? For RPMs, I know
that /var/lib/mysql is the directory where tables are kept. The
/var/lib/mysql/mysql directory is the security tables. Other directories
are created when you create databases.
>
> I don't know,but it can't find them because the script immediately ends.
> The listing
> of the /var/lib/mysql is:
> [root@localhost mysql]# ls -l
> total 12
> -rw-r--r-- 1 mysql root 1192 Mar 7 19:43
> localhost.localdomain.er
> r
> drwx------ 2 root root 4096 Mar 5 22:19 mysql
> srwxrwxrwx 1 mysql mysql 0 Mar 7 19:43 mysql.sock
> drwx------ 2 root root 4096 Mar 5 22:19 test
Strange, looks like the socket file didn't get deleted properly when mysqld
ended.
> Any help would be appreciated, I have a school project deadline coming up
> with JDBC and my
> problem is with this database more than the code. I would prefer to use
> mysql, but if I can't
> get it running, I might have to use MSAccess :-(
> *Also the error log states this
> 010307 19:43:47 mysqld started
> 010307 19:43:48 /usr/libexec/mysqld: Can't find file: './mysql/host.frm'
> (errno
> : 13)
> 010307 19:43:48 mysqld ended
>
> I don't know what that means, nor how to create the file host.frm
The host.frm is part of the security tables and was created (or should have
been) when you ran mysql_install_db
>
> The two suggestions I got were 1: to check the permissions on
> /var/lib/mysql, it was wrong and I have it now as:
> [root@localhost lib]# ls -l
> total 28
> drwxr-xr-x 2 root root 4096 Feb 6 1996 games
> -rw-r--r-- 1 root root 315 Mar 7 04:02 logrotate.status
> drwxr-xr-x 2 root root 4096 May 15 2000 misc
> drwxr-xr-x 4 mysql mysql 4096 Mar 7 19:43 mysql
> drwxr-xr-x 3 root root 4096 Mar 5 17:01 nfs
> drwxr-xr-x 2 root root 4096 Feb 14 1996 rpm
> drwxr-x--- 2 root slocate 4096 Mar 7 04:02 slocate
>
> I noticed the mysql directory has mysql group and owner and I am trying to
> run this as root could this be the problem, because
> I checked and root is not a member of the mysql group, if so how do I
change
> this "properly".
No, it is supposed to run as mysql. Thing is, is it propagated down into
the subdirectories?
>
> The other suggestion was to get the rpms from redhat and/or mysql, I did
use
> the rpms off of the CD.
Suggest you use mysql's RPMS and not redhat's. Once I installed the RPMS
from mysql, I found everything was ready to go. Didn't even need to run
mysql_install_db.
>
> Thanks in advance,
> Joe
>
>
>
>
----------------------------------------------------------------------------
----
> ---------------------------------------------------------------------
> 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
