- This topic is empty.
-
AuthorPosts
-
-
July 4, 2003 at 4:40 pm #8083bilboMember
Hi,
I currently use a mysql database located on an ensim virtual private server (VPS). Is it possible to connect to a mysql database in this way. I asked the support desk at my ISP and they seemed to think that I was talking double dutch or something coz they didn't have a clue about odbc and the like.
All I got was “Its usually localhost isn't it?” Which may give a clue as to the level of technical ability the firstline support my ISP has.
Can anyone help me?
Kind regards,
Rob
-
July 4, 2003 at 8:22 pm #14644RiteshMember
Greetings
Yes!!! You can connect to your remote server using SQLyog provided you have correct permissions.
HTH
-
July 7, 2003 at 8:09 am #14645ShadowMember
Most users have problems connecting to dbs operating on ISP servers though…
-
July 7, 2003 at 10:10 am #14646bilboMember
I'll go back to my ISP and see if I can find someone who knows what the hell they are talking about!
I blame myself of course in that I should have asked questions like this b4 I signed a contract with them!
Thanks for your help.
Rob
ps. Even although I havent managed to use it yet your software looks awesome! Hopefully I'll get the opportunity to use it soon! 🙂
-
July 7, 2003 at 10:33 am #14647ShadowMember
Don't forget to ask them whether they allow direct connection to MySql, otherwise you may have to find ways to tunnel SQLyog to MySql!
-
July 7, 2003 at 10:47 am #14648bilboMember
Tunnel?
Now that sound interesting. can you expand?
-
July 7, 2003 at 11:01 am #14649RiteshMember
He means SSH Tunneling 😀
Many SQLyog users use SSH Tunneling to connect to MySQL securely.
-
July 7, 2003 at 1:14 pm #14650ShadowMember
Yes, that's exactly what I meant!
-
July 7, 2003 at 7:38 pm #14651SSSMember
If you are using Windows to connect, I suggest you use PuTTY, a free SSH tool that will connect to MySQL securely.
PuTTY, latest version is 0.53b (is pretty stable and works great!)
PuTTY: A Free Win32 Telnet/SSH Client
David Carlson has a great mini-tutorial on SSH in the MySQL.com documentation:
2.6.2.4 Connecting to a Remote MySQL from Windows with SSH
-
-
AuthorPosts
- You must be logged in to reply to this topic.