Results 1 to 6 of 6

Thread: ODBC access to mysql

  1. #1
    Junior Member
    Join Date
    Dec 2004
    Posts
    22

    Default ODBC access to mysql

    Is there any way to access a mysql DB running on my website via ODBC from my home computer? I have an excellent DB admin program to analyze differences between two DBs and I'd like to use it to analyze the diff between my dev server on my laptop and my production DB on my site.

    thanks!

  2. #2
    Administrator AndrewT's Avatar
    Join Date
    Mar 2004
    Location
    Tulsa, OK
    Posts
    3,640

    Default

    We do not allow remote MySQL connections. I'm sure it might be possible to use some sort of SSH tunneling but this is not something that we provide support on. It's not even really something we like users doing but we aren't actively pursuing it at this time.

  3. #3
    Senior Member
    Join Date
    Mar 2004
    Location
    Australia
    Posts
    183

    Default

    This FAQ might be helpful for you:

    http://forums.dathorn.com/showthread.php?t=216

  4. #4
    Senior Member
    Join Date
    Sep 2005
    Location
    Russia, Nizhny Novgorod
    Posts
    315

    Default

    Yeah, that works (I guess you want to run SQLYog?), but database comparasion generates A LOT of subsequent queries and might easely put you into trouble with Andrew and excessive ressource usage on large databases

    Other than that, sometimes, this is a really handy and secure feature if you set it up correctly.

  5. #5
    Junior Member
    Join Date
    Dec 2004
    Posts
    22

    Default

    [QUOTE=ZYV;15209]Yeah, that works (I guess you want to run SQLYog?)QUOTE]

    Why, you must be a genius! SQLYog is the handiest utility I've found in a while!!! I LOVE it!

    I'll check the post. thanks. Don't plan to use it for much. Just to sync db structure from time to time and manually update data.

  6. #6
    Senior Member
    Join Date
    Sep 2005
    Location
    Russia, Nizhny Novgorod
    Posts
    315

    Default

    After the launch of SQLYog Community Edition it immediately became quite popular amongst the mySQL developers, who were normally repelled by the price tag of the Enterprise edition. Also I don't know many other mySQL interfaces with database sync and comparison features.

    By the way, Enterprise edition supports SSH tunneling out of the box, so I guess you won't even need Putty if you're the happy owner of this version. Still, be carefull about ressource usage.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •