Problem s mysql 3.23.41
Hrabcak Rado
hrabcak na phf.euke.sk
Pondělí Září 17 17:34:49 CEST 2001
Zdravim Vas,
mam taky neprijemny problem s mysql 3.23.41
Po skompilovani zo src.rpm a vytvoreni rpmiek a instalacii databazy aj
klientskeho softwaru pre linux som objavil problem.
Nedokazem zobrazit existujuce tabulky ani databazy, ked tabulka existuje a
urobim nad nou select ide. Ale Ked skusim: show tables; nezobrazi sa nic.
Podrobnejsie informacie su v bugreporte, ktory som vygeneroval.
Neviem ci je to bug, alebo ja niekde robim chybu.
Dakujem.
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: duffy na duffy.sk
To: mysql na lists.mysql.com
Subject: Invisible tables and databases in mysql
>Description:
Hello, I have the problem with seeing tables and databases in mysql
client, or mysqlshow or via any gui e.g. PHP clients, or if I try
with SQL command show tables, or show databases. When I want to obtain
list of tables via php I receive Error #1146 (concelated). But when I
try in mysql console client select form some existing table it works
well.
>How-To-Repeat:
[root na snowball: mysql] # mysql -u root -p -h snowball
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 3.23.41
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> \u mysql
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql>
*******************************************************************************
mysql> status
--------------
mysql Ver 11.15 Distrib 3.23.41, for pc-linux-gnu (i686)
Connection id: 6
Current database: mysql
Current user: root na snowball
Current pager: stdout
Using outfile: ''
Server version: 3.23.41
Protocol version: 10
Connection: snowball via TCP/IP
Client characterset: latin1
Server characterset: latin1
TCP port: 3306
Uptime: 3 min 33 sec
Threads: 1 Questions: 15 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1 Queries per second avg: 0.070
--------------
mysql>
*******************************************************************************
[root na snowball: /root] # cd /var/lib/mysql/
[root na snowball: mysql] # ls
mysql mysql.sock snowball.err snowball.pid test
[root na snowball: mysql] # less snowball.err
010907 10:50:03 mysqld started
/usr/sbin/mysqld: ready for connections
*******************************************************************************
mysql> select * from user;
-----+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv | Insert_priv | Update_priv
| Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost | root | 12b3c8f327e5e998 | Y | Y | Y
| Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y |
| snowball | root | 12b3c8f327e5e998 | Y | Y | Y
| Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y | Y |
| localhost | | | N | N | N
| N | N | N | N | N | N
| N | N | N | N | N |
| snowball | | | N | N | N
| N | N | N | N | N | N
| N | N | N | N | N |
+-----------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
4 rows in set (0.00 sec)
*******************************************************************************
mysql> explain select * from user;
+-------+------+---------------+------+---------+------+------+-------+
| table | type | possible_keys | key | key_len | ref | rows | Extra |
+-------+------+---------------+------+---------+------+------+-------+
| user | ALL | NULL | NULL | NULL | NULL | 4 | |
+-------+------+---------------+------+---------+------+------+-------+
1 row in set (0.00 sec)
*******************************************************************************
mysql> show databases;
+----------+
| Database |
+----------+
| |
| |
| |
| |
| |
| |
| |
+----------+
7 rows in set (0.00 sec)
*******************************************************************************
Error #1146 (concelated)
*******************************************************************************
[root na snowball: /root] # mysqlshow -u root -p
Enter password:
+-----------+
| Databases |
+-----------+
| |
| |
| |
| |
| |
| |
| |
| |
| |
+-----------+
*******************************************************************************
[root na snowball: /root] # mysqlshow -u root -p -v
Enter password:
+-----------+--------+
| Databases | Tables |
+-----------+--------+
| | N/A |
| | N/A |
| | N/A |
| | N/A |
| | N/A |
| | N/A |
| | N/A |
| | N/A |
| | N/A |
+-----------+--------+
9 rows in set.
*******************************************************************************
>Fix:
<how to correct or work around the problem, if known (multiple lines)>
>Submitter-Id: duffy na duffy.sk
>Originator: root
>Organization:
Radovan Hrabcak
>MySQL support: none
>Synopsis: Problems with seeing mysql tables and databases
>Severity: serious
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.41 (Official MySQL RPM)
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux snowball 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686 unknown
Architecture: i686 (AMD Athlon)
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' CXXFLAGS=' -O3 -felide-constructors -fno-exceptions -fno-rtti ' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 mar 31 01:20 /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-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM'
--
rado (duffy) hrabcak
.
.t-e-l. + 421 905 669 362 .m-a-i-l. duffy na duffy.sk
.i-c-q. 25915231 .w-e-b. www.duffy.sk
Další informace o konferenci Test