Location: SQL Services/Setup Remote MySQL Server
You can change the MySQL server from the local server ("localhost") to point to a remote server. This allows MySQL functions to be performed by another computer.
1. When the page loads, set the following:
Remote Server Info
Remote server address (ip address or FQDN) - Enter the server ip address or Fully Qualified Domain Name in the text box provided.
Remote SSH port
- Enter the SSH port of the remote server in the text box provided. By
default, port 22 is entered. Change the port number accordingly.
Authentication
Login as - Select to login as either "Root" or "User (default)."
Select authentication method - Select either "Password" or "Public Key (default)" as the authentication method.
~ Username - Enter the username of the server for authentication.
~ Password - Enter the password of the server for authentication.
Select an installed SSH Key - Select the appropriate installed SSH Key from the drop down menu.
~ SSH Key Password (if required) - If required, enter the SSH Key password in the text box provided.
Choose a root escalation method - You can choose either "su" or "sudo" as the root escalation method.
Use Ftp to transfer cpmove files - If you want to use FTP as the transfer method, click on the check box.
Notes: You must be able to connect via ssh from this server's IP address for this to work properly. MySQL, Perl, and rsync must already be installed on the remote server.
2. Click on the "Setup" button.