How to Use WHM to Create MySQL Profiles

This tutorial outlines the process of creating MySQL profiles via WHM. MySQL profiles govern the data linking between local or remote MySQL servers, and root users have the ability to both create and manage these profiles.

Follow the steps-

1. Log in to WHM.
2. Select “SQL Services” option and click on the “Manage MySQL Profiles” sub-option.
   
3.  Click “+Add Profile” button from the right side of the screen.
   
4. A form type screen will open up. Fill in the information-
    Profile Settings
   
   1. Profile Name- Enter the profile name.
   2. Configuration Method- Choose the configuration method. Decide whether you want to create it automatically by generating a MySQL superuser through SSH, or manually input the credentials of an existing MySQL superuser.
      
      Host settings-
      
      1. Host- Input the IP address or hostname of the MySQL server.
      2. SSH Port- Enter the SSH port.
         
         Login Information-
         
         1. Username- Enter login username.
            
            Authentication Method-
            
            1. If you opt for the “Password” authentication method, input the “Password” and “Escalation Method”.
               
            2.  If you choose “SSH Key” as the authentication method, input the “SSH Key” and “Escalation Method”.
               
            3. Click on the “Save” button.