Description:
problems starting safe_mysqld --user=mysql &
How-To-Repeat:
OK, I tested this on two different servers and got the same results
with each. Both of the servers have a fresh install of RH 7.0 with
all of the rpm from the cd's. The version numbers for mysql are as
follows:
mysql-mysql-3.23.22-6
mysql-devel-3.23.22-6
mysql-server-3.23.22-6
php-mysql-4.0.1pl2-9
After installing the rpms, I located the scripts for mysql at:
'/usr/bin/mysql_install_db'
and '/usr/bin/safe_mysqld'
Next, I did a 'cd /usr' to get to that directory. Then I did:
./bin/mysql_install_db
I got the standard text, it created the grant tables and it issued
the standard warning about changing the root password.
Next, I did:
./bin/safe_mysqld --user=mysql &
and got this :
[root@opus /usr]# ./bin/safe_mysqld --user=mysql &
[1] 7764
[root@opus /usr]# Starting mysqld daemon with databases from
/var/lib/mysql
010117 16:24:56 mysqld ended
-------------------------------------
I checked the log and saw this:
010117 16:24:54 mysqld started
010117 16:24:56 /usr/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
010117 16:24:56 mysqld ended
-------------------------------------
Now, I saw in the documentation web pages that this means that
either the grant table
did not get created, or that I did not run the './bin/safe_mysqld'
exactly as shown.
I assure you I did, as shown above. What could be the problem?
I tried this once before with the 3-22 version and it worked! I'm
switching back
for now, but would appreciate some assistance with this.
Thanks.
System: Linux opus 2.2.16-22 #1 Tue Aug 22 16:16:55 EDT 2000 i586 unknown
Architecture: i586
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/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.0)
Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++'
CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 Jan 16 00:15 /lib/libc.so.6 ->
libc-2.1.92.so
-rwxr-xr-x 1 root root 4686077 Aug 30 17:17 /lib/libc-2.1.92.so
-rw-r--r-- 1 root root 22607104 Aug 30 17:15 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Aug 30 17:15 /usr/lib/libc.so
Configure command: ./configure i386-redhat-linux --prefix=/usr
--exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc
--datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib
--libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com
--mandir=/usr/share/man --infodir=/usr/share/info --without-debug
--without-readline --enable-shared --with-extra-charsets=complex
--without-bench --localstatedir=/var/lib/mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --enable-assembler
--with-mysqld-user=mysql
---------------------------------------------------------------------
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