Not working with MySQL

• Reporter: (Anonymous)
• 소유자: (None)
• Type: Bugs
• Status: Open
• Component: (None)
• MileStone: (None)
• Priority: 5 - Medium
• Severity: 5 - Medium
• Resolution: None
• File: 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

댓글 올리기

Logged In: YES
user_id=31258

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

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

댓글 올리기

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

댓글 올리기

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

댓글 올리기

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.