Mysql database not seen....

[Anon]

Hi all...
I m running Mysql 3.23.26 on Redhat Linux.. On some systems Mysql is working perfectly and some systems its not showing the database with the show database query... i get the following error...

mysql> show databases;
+----------+
| Database |
+----------+
| |
| |
| |
| |
| |
| |
| |
| |
+----------+
8 rows in set (0.00 sec)

mysql>

can any one tell me how to solve this problem...

[Anon]

try

create database foobar;

what is the problem???

[Anon]

If you looked a little closer at the first poster's example you would see "8 rows in set" - i.e there are databases already they are just not seen when using the mysql command line client. I have the exact same problem. Everything is there and works but "show databases" and "show tables" doesn't print anything...

[Anon]

show databases produces a result set... then you have to loop through to records.