Not working with MySQL

• 回報者: (匿名)
• 負責人: (無)
• 類型: 問題回報
• 狀態: 開啟
• 元件: (無)
• 里程碑: (無)
• 優先權: 5 - 中
• 嚴重程度: 5 - 中
• 處理結果: 無
• 檔案: 3

細節

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.