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

Error when logging on to second database

forums forums SQLyog SQLyog: Bugs / Feature Requests Error when logging on to second database

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • #9056
      Frizzled
      Member

      If you log into one database with the SSH tunnel, then choose Connect from the File menu and log into a localhost database (one on your computer). You will get an error from the server you are SSH'd to saying access was denied. :huh:

      It looks like the program is trying to use the SSH tunnel to connect to the second database.

      However … if you log into the localhost database first, then use the SSH tunnel to log into the remote database, you won't get an error and both connections will work 😀

      Great program!

      _f

    • #18179
      Ritesh
      Member

      What is the local port value you are providing in your SSH Tunnel option?

    • #18180
      Frizzled
      Member

      I'm just using the default settings, so it's local port 3306 and ssh port 22 for the remote DB.

      The localhost DB does not have the SSH tunnel box checked.

      I'm pretty sure this is a bug (although, it could still be my fault 🙂 ), because if I reverse which one I connect to first (connect to localhost first then connect to remote with SSH tunnel) I don't get an error.

      But, if I connect to the remote first (SSH tunnel), then I connect to my localhost – I get the error and the message is coming from the remote DB.

      _f

    • #18181
      Ritesh
      Member

      Change your local port to 3307 and try again.

      I believe that you have a MySQL server running on your local machine listening on port 3306.

Viewing 3 reply threads
  • You must be logged in to reply to this topic.