data synchronization

[Gilmer Donis]

Hello.

I'm using SQLYog Enterprise, and I have a remote server, so it is in other location,

I made connexion trough Norton, pc-anywhere (tcp/ip), my question is how

can I configure SQLYog to access to the remote database installed in that server, and execute some querys or copy databases, or Is there any other

way to do this with out using pc-anywhere?

Thanks for your help.

[peterlaursen]

3 ways to do that:

1) Direct connction. Simply enter the ip of the remote server or an URL describing its location in Connection Manager “MySQL Host Adress” field. If server is behind a router or firewall they should of course be configured appropriately.

2) HTTP-tunneling. If there is a webserver (such as MS IIS, Apache etc) running un that remote server too, you can use HTTP/HTTPS tunnelling, if you install the php preprocessor as a module with the webserver. Php ver 4 i preferred for connecting with SQLyog. Php_mysql extension must be enabled in php-configuration. You must upload the HTTP-tunneling file (found in SQLyog installation dirctory) to a localtion on the server accessible for the webserver. You enter detail in Connection Manager's “Tunnel” tab

3) SSH-tunneling. You must then install an SSH-server program on the remote server. Accesible from http://www.openssh.org . If you have never used ssh before it can be a little complicated. But some help is in SQLyog help file, and if it is not enough feel free to write again!

[peterlaursen]

Quote:

Is there any other way to do this with out using pc-anywhere?

You won't need to use any sort of software like this. MySQL can not only connect to clients running on “localhost” but to clients everywhere in the world.

SQLyog and its “child” the SJA (Sqlyog Job Agent) are (a) MySQL client(s) and will connect to MySQL servers all over the word if Local Network Configuration on the remote place and User Confguration with the remote MySQL-server allows for it.

Please note that users created on the remote MySQL server most be given access to connect from remote places. By default MySQL gives only access from “localhost” to users. You can use the SQL wildcard '%' to specify from which hosts users may connect. Simply “%” means from everywhere!

It probably would be practical if you configured the ROOT or some ADMIN user (with appropriate privileges) to be allowed to connect from your local machine. Then you can even configure users on the remote host from SQLyog on your local machine. If it located with an ISP you may however experience that they only allow for user configuration using their own “Control Panel” application.

[Gilmer Donis]

peterlaursen

Thanks a lot, I tried the third option locally you told me, and it works, later I will try with the remote server, but that was a lot of help. I appreciate.

Now I want to bother you with a second question, if you don't mind of course, or maybe someone else who wants to help me. What do I have to do, to make the remote connexion to MySQL database using an ODBC, is it possible having OPENSSH well configured?. this is because I have a small system that uses an ODBC to connect to the database, and I don't see how to tell the ODBC, to use SSH.

[peterlaursen]

I'd let someone else answer this question

Quote:

What do I have to do, to make the remote connexion to MySQL database using an ODBC, is it possible having OPENSSH well configured?

Anything I could say on that would be so unprecise that it won't be any use!

[Author]

Posts