(Home >> SQL Services >> Manage MySQL Profiles)
This interface allows you to manage multiple MySQL® server profiles. A profile defines the connection information for a local or remote MySQL server. You may wish to use a separate MySQL server if, for example, you own particularly busy servers or servers with large databases. You can offload MySQL-related work to the remote MySQL server.
The Manage MySQL Profiles interface configures the remote server to work with your MySQL setup. Before you set up a remote MySQL server, ensure that you install the
openssh-clients package on your server. You cannot set up a remote MySQL server without this package.
After you configure the remote server, you must manually transfer your existing MySQL data to that server and configure your accounts' applications to use that server. Any new databases that you create will exist on the remote MySQL server.
The interface displays the following columns for each MySQL profile:
|Profile||The name of the MySQL server profile.|
The MySQL server's IP address or hostname.
The MySQL server's port number.
|User||The SSH or MySQL username that you will use to authenticate to this host.|
|Type||A description of the profile data.|
Click one of the following icons to perform the appropriate action:
If no active profile exists, the system uses the information in the
To create a new MySQL profile, perform the following steps:
Enter the desired MySQL profile name in the Profile Name text box.
After you save the MySQL profile name, you cannot change it.
Manually enter an existing MySQL superuser's credentials — Select this method to manually enter the new profile's information.
Enter the appropriate information for the configuration method that you selected. For more information, click a tab to view information about that method's settings:
For more information, read our Troubleshoot MySQL® Profiles documentation.