Connecting to a MySQL database remotely

by oneafrikan on December 6, 2004

I’ve been trying to connect to my database remotely – really would prefer not to have to do .sql file exports if I could possibly avoid it…

No luck yet (will try more soon), but so far I’ve come accross this MySQL documentation, which should shed some light, and this forum thread on the SW Soft Plesk forum, which is also interesting.

Anyways – looks like a System DSN is necessary, along with a user name and password configured to allow connections from a specific machine…

2 comments

hello there,
i am trying to reproduce a data server that a company uses to present information to its customers via the web. No problem. What they are using right now is Microsoft Access, connecting via ODBC to a server on line. The cool thing that they can do is have several tables linked together. Like if a certain field is updated in one table, it updates the same info automatically in another table. So, i want to reproduce this in MySQL, but i can’t seem to find out how. Is there a way to pull this off on the server side ? or does that have to be done on the client side ?
thanks for any tips.

by digital camera on September 20, 2006 at 2:58 pm. Reply #

Mmmm… to be honest I’ve never had to do this, so I’m not entirely sure where to start.

My guess would either be to do a sync of the database to which you’ll need access using ssh or something secure like that; or
to run a script which take a row from one database, compares the values to the ones in the other database, and then does the update if necessary. To do this you would probably want to run a webservice which sends the data snippets accross to be compared.

Does that help? ;-)

by Gareth Knight on September 21, 2006 at 3:36 pm. Reply #

Leave your comment

Required.

Required. Not published.

If you have one.

Protected with IP Blacklist CloudIP Blacklist Cloud