On Sat, 1 Sep 2001, Sinisa Milivojevic wrote:
> Simon J Mudd writes:
> > I've not been using mysql for some time but did have it running for a
> > couple of small databases I use at home. It doesn't appear to work now,
> > the most obvious sympton being that msyqlshow shows a list of blank table
> > names.
>
> <cut>
> > I'm sure that I'm doing something wrong which is in a FAQ but can't find
> > the answer at the moment. Any suggestions are greatly appreciated.
>
> Run:
>
> SHOW DATABASES
This gives me:
[sjmudd@phoenix sjmudd]$ mysql --host=phoenix
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 20 to server version: 3.23.36
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> show databases;
+----------+
| Database |
+----------+
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
+----------+
15 rows in set (0.00 sec)
mysql>
> and see if you get any output. It could be a bug in mysqlshow.
looks like mysql is at least being consistent:
[sjmudd@phoenix sjmudd]$ mysqlshow --host=phoenix
+-----------+
| Databases |
+-----------+
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
+-----------+
[sjmudd@phoenix sjmudd]$
> Also check that your server was not started with --safe-show-database.
It is using the standard MySQL /etc/rc.d/init.d/mysql SysV startup script.
The database information does appear to be available as knowing the
database and table names allows me to access the information. Perhaps it
is a "permissions" problem?
------ snip ----
[sjmudd@phoenix sjmudd]$ mysql --host=phoenix
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 22 to server version: 3.23.36
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql> use negatives;
Database changed
mysql> select count(*) from negatives;
+----------+
| count(*) |
+----------+
| 314 |
+----------+
1 row in set (0.09 sec)
mysql> show tables;
Empty set (0.01 sec)
mysql>
--------- snip -----
Having not been subscribed to this list for some time, maybe I'm missing
out on something really obvious.
Regards,
Simon
--
Simon J Mudd, Madrid SPAIN. email: [EMAIL PROTECTED]
Tel: +34-91-408 4878, Mobile: +34-605-085 219
---------------------------------------------------------------------
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
