Connect But No Tables

[steveF]

Hello, I finally can connect but can not get tables to show up. if i try to do any thing i get 1044 error. If I try to use the manage users i get the attached window. Any ideas.

Thanks for help. I downloaded the trial 5.21

[MarkRH]

I've just tried 5.21 Enterprise and the last 5.22 Enterprise Beta and they both give me the 1044 Access Denied error when I click on the Object Browser or Click on the Database name to get the list of tables. This happens when connecting to my database at the webhost (I've made sure my hostname is a host that can access it via their control panel).

Works fine connecting locally to my local MySQL server.

I've sent a support ticket to the hosting company as well to see if they've changed something. About all I can do is SHOW VARIABLES and SHOW PROCESSLIST. Seems like a privalege problem on their end or SQLyog is doing something hinky now.

All the PHP scripts at the webhost work fine with the databases.

It all used to work.. but it has been awhile since I've tried connecting remotely.

Wonder if I'll have to use the HTTP tunneling business now..

[MarkRH]

Problem is fixed for me. It was an issue with the webhost. I had to remove and re-add the allowed users for my databases after changing the allowed access hosts in the cPanel MySQL interface.

I guess this recreated the entries in their mysql.user table to the correct host/db/user combinations.

Mark H.

[peterlaursen]

It is an issue with the webhost (privilege issue to the Information_Schema).

However with 5.22 RC3 we send different queries, so (execept for Triggers) it should work .. even with that issue on the host.

[Author]

Posts