Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Include Page
_Version
_Version

(Home >> SQL Services >> Manage MySQL Profiles)

Table of Contents
stylenone

Overview

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.

Remote MySQL server information

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.

Warning
titleWarnings:
  • This feature does not automatically transfer your MySQL data.
  • Do not use the skip-name-resolve option in your server's MySQL configuration. This option can cause problems on any server. It will create more problems on remote MySQL servers, during account transfers and restorations, and with phpMyAdmin.

MySQL Profile information

The interface displays the following columns for each MySQL profile:

ColumnDescription
ProfileThe name of the MySQL server profile.
Host

The MySQL server's IP address or hostname.

Port

The MySQL server's port number.

UserThe SSH or MySQL username that you will use to authenticate to this host.
TypeA 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 () — Set this profile as the active profile.
    A green lightning bolt icon () indicates the currently-active profile. 

    Note
    titleNote:

    You may only select one active profile at a time.


  • Delete () — Delete the profile.

    Note
    titleNote:

    You cannot delete the active profile.


  • () — Edit the profile.

Add profile

Note
titleNote:

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:

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

    Note
    titleNote:

    After you save the MySQL profile name, you cannot change it. 


  3. 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.

      Warning
      titleImportant:
      • To create a MySQL super user, you must enable the Super privilege in the Privileges section of the phpMyAdmin interface (Home >> SQL Services >> phpMyAdmin).
      • Amazon Relational Database Service (RDS) does not allow you to enable the Super privilege.


  4. 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:

    Localtab Group


    Localtab
    titleAutomatically create a MySQL superuser via SSH.


    SettingDescription

    Host

    The MySQL server's IP address or hostname.

    Warning
    titleWarning:

    You must ensure that the MySQL server can resolve the cPanel & WHM server's IP address to its fully-qualified hostname, regardless of whether you enter a public or private IP address.


    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
    titleNote:

    This setting only appears when you select the Password for the Authentication Method setting.


    SSH Key

    The name of the SSH key to use to log in to the remote server.

    Note
    titleNotes:
    • This setting only appears when you select the 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.




    Localtab
    titleManually enter an existing MySQL superuser's credentials.


    SettingDescription

    Host

    The MySQL server's IP address or hostname.

    Warning
    titleWarning:

    You must ensure that the MySQL server can resolve the cPanel & WHM server's IP address to its fully-qualified hostname, regardless of whether you enter a public or private IP address.


    SSH Port

    The SSH port number. You must enter a port number between 1 and 65535.

    Username

    The MySQL superuser's username.

    Password

    The MySQL superuser's password.




  5. Click Save.

For more information, read our Troubleshoot MySQL® Profiles documentation.