How to Create MySQL Profiles through WHM

August 24, 2023 / MySQL

This guide explains how to create MySQL profiles through WHM. MySQL profiles control all the data for the linking between the local or remote MySQL server. Root users can create and manage new MySQL profiles.

Let us follow the steps:

  1. Log in to WHM.
  2. Select “SQL Services” category from the left-hand side menu and click on the “Manage MySQL profiles” sub-option.
    SQL services
  3. You will find previously added MySQL profiles.
    Manage MySQL
  4. Click on the “+Add Profile” button on the right side.
    Add profile
  5. As soon as you click this button, a form will appear.
    1. Profile Settings-
      1. Profile Name- Enter the profile name.
      2. Configuration Method- Select the configuration method. Whether you want to create automatically create a MySQL superuser via SSH or manually enter an existing MySQL superuser’s credentials.
        Add profile
    2. Host settings-
      1. Host- Input the IP address or hostname of the MySQL server.
      2. SSH Port- Enter the SSH port.
        Host settings
    3. Login Information-
      1. Username- Enter login username.
      2. Authentication Method- Choose the authentication method.
        1. If you select “Password” as the authentication method. Enter the password.
          Login information
        2. If you select “SSH Key” as the authentication method, then enter the SSH Key and SSH Key Passphrase.
          SSH key
  6. Click on the “Save” button.

This way the new MySQL profile will be added to the list. You can use this method and create new MySQL® profiles with WHM. For more information, contact our support team.

Spread the love