Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Connect But No Tables

forums › forums › SQLyog › Using SQLyog › Connect But No Tables

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • December 31, 2006 at 10:06 pm #23182
      MarkRH
      Member

      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..

    • January 1, 2007 at 12:09 am #23183
      MarkRH
      Member

      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.

    • January 2, 2007 at 5:15 am #23184
      peterlaursen
      Participant

      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
Viewing 2 reply threads
  • You must be logged in to reply to this topic.