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

Lost Connection

forums › forums › SQLyog › Using SQLyog › Lost Connection

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • April 27, 2006 at 4:31 pm #9649
      peterlaursen
      Participant

      Bob Montejo added this comment to the FAQ:

      I'm new to mysql but I did have everything working. I installed stunnel between my client and mysql server. Before using stunnel, SQLyog was working fine and connecting to the server via port 3306. I tried using it after running stunnel but I got error 2003, no problem – I changed the connection to port 3307 and connected fine. When I changed the port, SQLyog asked me if I want to save the file and I said yes. Since then I lost my connection between my client and the server. I checked the server and mysql is listening on 3307. What file did SQLyog change in my server? I did a “find” in the server but I didn't find any “my.cnf”. Would appreciate any help in this regard.

    • April 27, 2006 at 4:49 pm #21437
      peterlaursen
      Participant

      SQLyog does not change any files on the server. It has no access to do so either! It is only connection details that are saved to the sqlyog.ini file on your local machine.

      “Since then I lost my connection between my client and the server” What client are you talking about here? A client on the server or on your local? If it the 'mysql' client did you change the port setting in the [client] section of the my.cnf file as well?

      I have no experience with the 'stunnel' program and do not know what it does. Is this a client for Windows or a SSH-add on for Linux? Most people use Putty for creating a SSH connection to a shell session on *nix. There is no issue with running Putty and SQLyog at the same time. Do you use this 'stunnel' with SQLyog somehow? SQLyog Enterprise has a SSH-tunneller of its own.

      “I did a “find” in the server but I didn't find any “my.cnf” “. I really do not understand how you can change the MySQL port without having acces to the MySQL configuration file. Are you sure that you started the search form the OS's root folder ('/' not to be mismatched with '/root') .It should be in /etc folder (guess it is Linux?)

      Please explain a little bit more – if you still have problems.

    • April 27, 2006 at 5:32 pm #21438
      peterlaursen
      Participant

      I research a little and found this:

      http://stunnel.mirt.net/

      If you want to experiment with this you are on your own!

      We provide SQLyog Enterprise for SSH-encrypted connections to MySQL.

    • April 27, 2006 at 9:24 pm #21439
      Ritesh
      Member

      One dosnt need to use Stunnel. plink should work great!

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