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. A separate server for MySQL is useful, for example, for busy servers or servers with large databases. You can offload MySQL-related work to the remote MySQL server.

Warnings:

This feature does not automatically transfer your MySQL data. Instead, it configures the remote server to work with your MySQL setup. After you configure the remote server, you must manually transfer your existing MySQL data. Any new databases that you create will exist on the remote MySQL server.
Do not confuse this feature with the ability to allow access to a MySQL database from a remote server. To configure that option, use WHM's Additional MySQL Access Hosts interface (Home >> SQL Services >> Additional MySQL Access Hosts).
We strongly recommend that each remote MySQL server correspond to a single cPanel & WHM server. While you can use a single remote MySQL server for multiple cPanel & WHM servers, we do not recommend this configuration.
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.

MySQL server profiles

The table displays the following columns for each MySQL profile:

Column	Description
Profile	The name of the MySQL server profile.
Host	The MySQL server's IP address or hostname.
Port	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.
Actions	Click one of the following icons to perform the appropriate action: Validate () — Test the profile's MySQL server settings. Activate () — Make this profile the active profile. A green lightning bolt icon () marks the currently-active profile. Note: You may only select one active profile at a time. Delete () — Delete the profile. Note: You cannot delete the active profile. () — Edit the profile.

Add profile

Note:

If no active profile exists, the system uses the information in the /root/.my.cnf file to generate an active profile.

To create a new MySQL profile, perform the following steps:

Click Add Profile. A new interface will appear.
Enter the desired MySQL profile name in the Profile Name text box.

Note:

After you save the MySQL profile name, you cannot change it.
Select a method to use to configure the new profile:
- Automatically create a MySQL superuser via SSH— Select this method to create the new profile manually.
- 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:

Setting	Description
Host	The MySQL server's IP address or hostname.
Port	The MySQL server's port number. You must enter a port number that is between `1` and `65535`.
Username	The username for the SSH connection.
Authentication Method	Select the desired authentication method. Password — Use a password to authenticate. Enter your SSH password in the Password text box. SSH Key — Use an SSH key to authenticate. Enter your SSH key's name in the SSH Key text box.
Password	The password for the SSH connection. Note: This setting only appears when you select Password for the Authentication Method setting.
SSH Key	The name of the SSH key to use to log in to the remote server. Notes: This setting only appears when you select SSH Key for the Authentication Method setting. Use WHM's Manage Root's SSH Keys interface (Home >> Security >> Manage Root's SSH Keys) to add SSH keys.

Click Save.

Knowledgebase

Categories

Categories