No tables shown on connection

[harsh_t]

Hi!

I just installed SQYlog free edition and am trying to connect to a Linux server on my LAN. I enter the IP address and root password on the connection screen and I see a list of databases which is correct so a connection is definitely established. However, I can see the table structure on only one of the databases. All the others are blank. Can anyone help with this?

Thanks

Harsh

[peterlaursen]

If you understand, that you must “unfold” the browser tree by clicking the “+” with the mouse, it sounds pretty strange!

I doubt this is an issue with SQLyog. Did you try other clients ? “MySQL Administrator” or “MySQL Query Browser” for instance ?

1)

Try pressing the “refresh”-button after connection is established (it's the one with the “recycle”-symbol)

2)

Also try issuing this SQL from the SQL-pane in SQLyog “show tables from my_db” with one of the blank databases as “my_db”` Do you get any eror message with that ?

[Ritesh]

I believe he does not have permission for the other databases.

[harsh_t]

Thanks for the quick reply

Yes I had tried to expand the + sign. Tables do appear for the one databse and not for all the others though the + signs are shown for all of them.

I tried refreshing – no luck

I tried “show tables” No error, just ” 0 rows returned”

I checked permissions in Linux, they are exactly the same for all the databases.

When I try to select the database from the dropdown list just below the menu bar, I get

Error 1044 “Access denied for user: root@ to database 'dbname'”

Any suggestions?

Thanks

Harsh

[Ritesh]

More information on the MySQL privilege system can be found at http://dev.mysql.com/doc/mysql/en/privileg…ege-system.html

[harsh_t]

Got the privileges sorted out. Works OK now.

Many thanks everyone

Harsh

[Author]

Posts