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

Connecting to Remote server from Dymanic IP

forums › forums › Connecting to Remote server from Dymanic IP

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • April 9, 2003 at 8:21 am #7821
      BlankCanvas
      Member

      Hi Everyone,

      I'm trying to find a method of managing my MySQL server from my laptop whilst on the move around various countries. Currently I have to conect to my server via a phpMyAdmin page to update the MYSQL HOST table with my current dialup's IP, reload MySQL and then use SQLyog to do my stuff.

      I tried registering a dymanic domain with http://www.no-ip.com which updated the DNS everytime I connect. This works no problems I even run a web server on it my friends us to chat with me.

      However when I put my host name in the table, it does not not allow me to connect.

      Any pointers on what other people have done appreciated.

      Thanks

      Stephen

    • April 9, 2003 at 9:34 pm #14043
      CalEvans
      Member

      If you have shell access to the server via ssh, use ssh to tunnel the mysql protocol.

      Here's what I do.

      My laptop is running windows 2000. I use SecureShell from http://www.vandyke.com.

      In the configuration for the connection to my server I have setup port forwarding for 3306.

      When I want to connect SQLyog to the server there I connect to the server using ssh and then connect SQLyog to localhost port 3306.

      This way I can remotely control my mysql server from any internet connection available.

      Clear as mud?

      =C=

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.