May be a red herring, however this ate several hours, so...
..enjoy! :->
>Description:
Possible problem with using the existing 3.23.41 SRC RPM distribution
This package may have some bug.
This is the source RPM package downloaded from mysql.com, with MD5-hash:
MySQL-3.23.41-1.src.rpm -- 91eb 9ef7 30cc 81a3 32d3 23dd baca 848a
The mysqld created by that distribution does not work correctly,
although it is being compiled without big ado.
Immediately after installation, I connect to MySQL:
mysql> SHOW DATABASES;
+----------+
| Database |
+----------+
| |
| |
| |
| |
| |
| |
| |
| |
+----------+
8 rows in set (0.00 sec)
mysql> USE mysql
Database changed
mysql> SHOW TABLES;
Empty set (0.00 sec)
mysql> DESCRIBE user;
+-----------------+-----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-----------------+------+-----+---------+-------+
| Host | char(60) binary | | PRI | | |
| User | char(16) binary | | PRI | | |
| Password | char(16) binary | | | | |
| Select_priv | enum('N','Y') | | | N | |
| Insert_priv | enum('N','Y') | | | N | |
| Update_priv | enum('N','Y') | | | N | |
| Delete_priv | enum('N','Y') | | | N | |
| Create_priv | enum('N','Y') | | | N | |
| Drop_priv | enum('N','Y') | | | N | |
| Reload_priv | enum('N','Y') | | | N | |
| Shutdown_priv | enum('N','Y') | | | N | |
| Process_priv | enum('N','Y') | | | N | |
| File_priv | enum('N','Y') | | | N | |
| Grant_priv | enum('N','Y') | | | N | |
| References_priv | enum('N','Y') | | | N | |
| Index_priv | enum('N','Y') | | | N | |
| Alter_priv | enum('N','Y') | | | N | |
+-----------------+-----------------+------+-----+---------+-------+
17 rows in set (0.00 sec)
>How-To-Repeat:
Not an intermittent bug
>Fix:
Downloaded the src tarball from mysql.com for version
3.23.41-1 with MD5-hash:
60ae e5de 4dba 86a7 4174 f2da 303c 4d36
Compiled the daemon and dropped the binary "mysqld" into place of the
existing RPM-issued mysqld (some fixing of my.cnf required). This does
the trick:
mysql> SHOW DATABASES;
+----------+
| Database |
+----------+
| mysql |
| test |
| tmp |
+----------+
3 rows in set (0.00 sec)
mysql> USE mysql
Database changed
mysql> SHOW TABLES\g
+-----------------+
| Tables_in_mysql |
+-----------------+
| columns_priv |
| db |
| func |
| host |
| tables_priv |
| user |
+-----------------+
6 rows in set (0.00 sec)
>Submitter-Id: David Tonhofer
>Originator: root
>Organization: m-plify S.A.
>MySQL support: none
>Synopsis: RPM package gives buggy msqld
>Severity: serious
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.41 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 8.21 Distrib 3.23.41, for pc-linux-gnu on
i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.41
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 29 min 56 sec
Threads: 1 Questions: 7 Slow queries: 0 Opens: 7 Flush tables: 1 Open
tables: 1 Queries per second avg: 0.004
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux neutrino 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686
unknown
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/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.0)
Compilation info: CC='egcs' CFLAGS=' -O3' CXX='egcs'
-O3 -felide-constructors -fno-exceptions -fno-rtti '
LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 Jul 4 17:02 /lib/libc.so.6 ->
libc-2.1.92.so
-rwxr-xr-x 1 root root 4776568 Aug 30 2000 /lib/libc-2.1.92.so
-rw-r--r-- 1 root root 22607104 Aug 30 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Aug 30 2000 /usr/lib/libc.so
Configure command:
./configure --disable-shared --with-mysqld-ldflags=-all-static --with-clien
t-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assemb
ler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.so
ck --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=
/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/my
sql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man
'--with-comment=Official MySQL RPM'
---------------------------------------------------------------------
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
