Connecting to MySQL

Skyvia supports usual TCP/IP MySQL connections and secure SSL and SSH MySQL connections.

To connect to a MySQL server, you need to specify the database server host name or IP address, the port the MySQL server is listening, the user name and password to login, and the database name.

note Important Note

Your MySQL server must be available through the Internet in order for Skyvia to connect to it.

If you are connecting to MySQL server on your local computer, allow such connections in your firewall. If you are connecting to a computer in your local network you should use port forwarding.

Skyvia will access your server from the IP 40.118.246.204.

mysql-connection-new

You need to specify the following parameters for TCP/IP MySQL connection:

Name - connection name that will be used to identify the connection on the Connections page and when selecting a connection for a package.
Server - the domain name or IP address of the MySQL Server host to which to connect. Please note that your MySQL Server host must be accessible from the Internet by this IP address or domain name. If you use an IP address for the Server parameter, this must be the external IP address of the host, not the internal one.
Port - MySQL Server connection port; default value is 3306.
User Id - the user name to login with.
Password - the password to login with.
Database - the name of the MySQL database you want to connect to.

note Important Note

If you need to pass UTF8 characters to a MySQL database, click the Advanced button and select the Unicode check box.

If you want to use SSL or SSH connection, additionally you need to click the Advanced button and select the required Protocol. After this, for SSL connection you need to specify:

SSL CA Cert - the authority certificate. Paste the content of the certificate file into the box or click the button to open a multiline editor and paste the content of the certificate file there.
SSL Cert - the client certificate. Paste the content of the certificate file into the box or click the button to open a multiline editor and paste the content of the certificate file there.
SSL Key - the client private key. Paste the content of the key file into the box or click the button to open a multiline editor and paste the content of the key file there.

For SSH connection specify the following:

SSH Authentication Type - the type of SSH authentication to use: Password or PublicKey. When using the password authentication you need to specify the SSH password. For public key authentication you need to specify the passphrase for the private key and the private key.
SSH Host - the name or IP address of the SSH server.
SSH Port - the TCP/IP port to connect to the SSH Server. By default, it is 22.
SSH User - the user name on the machine where the SSH Server is running. It is a Windows user, not a user of the MySQL Server.
SSH Password - the password of a user account on the SSH Server. Available if Password SSH Authentication Type is selected.
SSH Passphrase - the passphrase for a private key. You can set it while generating public and private key files through a key generator tool, for example PuTTygen. Available if PublicKey SSH Authentication Type is selected.
SSH Private Key - the private key.  Paste the content of the key file into the box or click the button to open a multiline editor and paste the content of the key file there. Available if PublicKey SSH Authentication Type is selected.

In the Advanced parameters you can also select the Unicode check box to use Unicode encoding for the connection and specify the Command Timeout interval. The latter specifies the wait time before terminating an attempt to execute a command and generating an error. Note that it is the time to wait for any server reply since the command was sent to a server, and it doesn't include the time necessary to fetch data if the command selects some data.

Additionally the Advanced parameters include the Connection Timeout parameter. This parameter determines the time (in seconds) to wait while trying to establish a connection before terminating the attempt and reporting an error. Generally you don't need to modify it, but in some specific cases when a connection to the database server is not good you may try increasing their values.