Add a new server using the ADVSoft SQL Backup management program:

Next, select the MySQL page and enter the required connection settings.

Two methods for connecting to the database server are supported:

Connection via TCP/IP (including ssh)

To connect via the TCP/IP protocol, you must specify the Host and Port of the MySQL server as well as the username and password:

Connecting through SSH

If necessary, you can connect via SSH by entering the appropriate settings.

In this case, you must enter your details for connecting to the SSH server (sshd daemon) in the SSH host/username/password fields, and you must enter the MySQL server address and its connection settings in the Host/Username/Password fields. You can also choose to install the SSH server and MySQL on more than one server. In this case, you will specify the internal address/name of the MySQL server instead of 127.0.0.1 (or localhost).

MySQL on *nix systems understands "localhost" and "127.0.0.1" as different addresses. For example, if the user test@127.0.0.1 is specified in the MySQL settings, then you should use 127.0.0.1 as an address. "localhost" will not be considered to be a valid address in this case. Similarly, if "localhost" is specified in the database server settings, then this value should also be specified in the "Host" field.

Connection via phpMyAdmin

To connect to MySQL through phpMyAdmin, select the appropriate tab and enter the connection URL, username and password:

Connectivity test

Check the connection by clicking on the "Test connection" button. You will see a corresponding message if the connection was successful.