Tíquete #11662

Not working with MySQL
: 2008-01-15 20:24 Última Atualização: 2008-03-08 08:37

Relator:
(Anônimo)
Dono:
(Nenhum)
Tipo:
Estado:
Aberto
Componente:
(Nenhum)
Marcos:
(Nenhum)
Prioridade:
5 - Medium
Gravidade:
5 - Medium
Resolução:
Nenhum
Arquivo:
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
Comentário
Logged In: YES
user_id=31258

Please execute "show tables".
What result do it become?
2008-01-17 20:42 Updated by: gozala
Comentário
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
Comentário
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
Comentário
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.

Attachment File List

Editar

Please login to add comment to this ticket » Login