Not working with MySQL

• Informador: (Anónimo)
• Propietario: (Ninguno)
• Tipo: Bugs
• Estado: Open
• Componente: (Ninguno)
• Hito: (Ninguno)
• Prioridad: 5 - Medium
• Gravedad: 5 - Medium
• Resolución: Ninguno
• Fichero: 3

Details

Not showing tables stred procedures ..etc in MySQL.
but quarry's are working normally

Ticket History (3/5 Histories)

2008-01-15 20:24 Updated by: None

• File 2144: Screenshot.png is attached

2008-01-15 23:07 Updated by: zigen

• File 2145: showTables.gif is attached

Comentario

Logged In: YES
user_id=31258

Please execute "show tables".
What result do it become?

2008-01-17 20:42 Updated by: gozala

Comentario

Logged In: YES
user_id=32935

In my situation I have no database selected
MySQL version 4.0.25-max

I changed connection string and wrote database.
But if don't want to specify database to see all other
scheme's I have privileges??

2008-01-17 21:03 Updated by: gozala

Comentario

Logged In: YES
user_id=32935

I think it is neede to execute
SHOW DATABASES;
to get all the databases like scheme's in Oracle,
and then get tables for each of database :)

Hope it will help!

PS: It is really important feature to see all the tables you
have access to.

2008-03-08 08:37 Updated by: zigen

• File 2225: newDBTree.gif is attached

Comentario

Logged In: YES
user_id=31258

Next Version(1.0.7)

Displaying "schema list" in MySQL5.
using "information_schema"

Please look at the attached file.