Not working with MySQL

• 报告人: (匿名)
• 属主: (无)
• 类型: Bugs
• 状态: 开启
• 组件: (无)
• 里程碑: (无)
• 优先: 5 - Medium
• 严重性: 5 - Medium
• 处理结果: 无
• 文件: 3

Details

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

任务单历史 (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.