Data Sync for MySQL online Help
Prev | Return to chapter overview | Next |
How to connect to MySQL
To compare two MySQL databases you need to connect to them first. Specify connection properties of the Source database and the Target database. In this case Data Sync for MySQL after the comparison prepares a synchronization script to be executed on the target database. To compare tables stored in one database, specify the connection properties once and use the Copy source to target or Copy target to source buttons.
Data Sync for MySQL allows you to connect to MySQL servers directly, via Secure SHell (SSH) tunnel or HTTP tunnel.
• | Direct connection |
It is the most natural and the most preferable connection mode. Use it each time it is possible. Most of hosting companies allow direct connections to databases. However in most cases you have to go to your control panel and add your home/office computer IP address or domain name to Access List - list of IP addresses allowed accessing from outside.
• | SSH tunnel connection |
If your MySQL server does not allow direct connections from your remote workstations, you can establish connection to an allowed intermediate SSH server and forward all MySQL commands through the Secure SHell (SSH) tunnel.
More about SSH tunnel connection
To establish connection to intermediate SSH server and forward all MySQL commands through the secure tunnel, you need to:
Host name Specify the host name or IP of your site. Note, that MySQL host name always should be set relatively to the SSH server. For example, if both of MySQL and SSH servers are located on the same computer, you should specify localhost as Host name instead of server's external host name or IP address.
Port number Enter the port number for the SSH server. 4. Enter valid User name for the remote server and select the Authentication method and set corresponding credentials.
Password-based Set the password corresponding to the specified user.
Key-based Specify the path to the Private key file with the corresponding Passphrase to log in to the remote server. Data Sync for MySQL accepts keys in ssh.com or OpenSSH formats. To convert a private key from PuTTY's format to one of the formats supported by our software, use the PuTTYgen utility that can be freely downloaded from the PuTTY website.
Keyboard interactive Keyboard authentication is the advanced form of password authentication, aimed specifically at the human operator as a client. During keyboard authentication zero or more prompts (questions) is presented to the user. The user should give the answer to each prompt (question). The number and contents of the questions are virtually not limited, so certain types of automated logins are also possible. |
• | HTTP tunnel connection |
HTTP tunneling is a technique used in conditions of restricted network connectivity including firewalled networks, networks behind proxy servers, and NATs. It is the slowest way and is recommended to use if the others are impossible.
More about connection via HTTP tunnel
To connect to a remote server using an HTTP tunnel, you need to:
Note: You are actually connecting to your database through the PHP script on the server, so in most cases the host/server name is "localhost" unless the target database server is not installed on the same computer as the Web server.
|
Irrespectively of a connection mode you should specify common credentials as follows:
Host
The host name of the MySQL server.
Port number
The TCP/IP port to use if server is not localhost.
User name
The username used to connect to MySQL.
Password
The password for the user account on server.