If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
These forums remain online primarily for archival purposes. While posting is still possible, it should not be considered a means for support. Please login to our portal and submit a ticket if you require assistance and we'll be more than happy to assist you.
Regular updates are posted to our blog and we will continue to post important notices to the Script Security forum section here. You can subscribe to that forum to automatically receive notifications.
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.
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.
Question:
Is direct connection to Dathorn MySQL server possible, without need to use web style admin?
Answer:
Yes, but...
For security reasons native remote direct connection to MySQL server is disabled. So, you cannot use MySQLFront or other similar MySQL admin application to connect directly. However, since there
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.
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.
Comment