Problem opening/finding default database when running mysqld through'safe_mysqld &' command...

[Chris Wagner]

>Description:
Firstly, I don't believe this is a bug, but I really can't figure it out.
I've installed MySQL through the Red Hat 8 distribution CDs. When I run safe_mysqld, I have the following message:

[root@localhost bin]# safe_mysqld &
[1] 25488
[root@localhost bin]# Starting mysqld daemon with databases from /var/lib/mysql
021213 01:53:09 mysqld ended

I check the log file, /var/log/mysqld.log, and it says:
/usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)

The log file changes each time I execute safe_mysqld, therefore I know this is the log file it is using. I have run the mysql_install_db script and it placed all of the default stuff (including host.frm) in /var/lib/mysql/mysql/. The permissions are all checked for 'User' and I am logged in as root. I've tried setting all the permissions completely for everyone and tried copying all the default database files to /var/lib/mysql/.

My my.cnf file contains the following:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


I'm also certain this file is being read, since I had to add skip-innodb, which was giving me another warning/error message.

Well, I'm pretty sure this is just something stupid I'm missing, but I would really appreciate some help. I've been looking through the manual, reading over the sections about trouble starting up several times... No luck.

>Submitter-Id: Chris Wagner
>Originator: root
>Organization:
None
>MySQL support: none
>Synopsis: Unable to run mysqld because it cannot find the default database which was installed with mysql_install_db
>Severity: non-critical
>Priority: low/medium
>Category: mysql
>Class: support ]
>Release: mysql-3.23.52 (Source distribution)

>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux localhost.localdomain 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux
Architecture: i686

Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit
Thread model: posix
gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' CXX='g++' CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 Dec 9 19:12 /lib/libc.so.6 -> libc-2.2.93.so
-rwxr-xr-x 2 root root 1235468 Sep 5 19:12 /lib/libc-2.2.93.so
-rw-r--r-- 1 root root 2233342 Sep 5 18:59 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Sep 5 18:50 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --datadir=/usr/share --libdir=/usr/lib --mandir=/usr/share/man --infodir=/usr/share/info --without-readline --without-debug --enable-shared --with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql --with-extra-charsets=all --with-innodb --enable-local-infile --enable-large-files=yes --enable-largefile=yes --with-berkeley-db --with-thread-safe-client 'CFLAGS=-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' 'CXXFLAGS=-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions'




Thanks a ton.


---------------------------------------------------------------------
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