Manage MySQL® Profile

Log in toWHM >>SQL Services >>Manage MySQL® Profile

• • • Select “SQL Services” category from the left-hand side menu and click on the “Manage MySQL profiles” sub-option.
    • You will find previously added MySQL profiles.
    • Click on the “+Add Profile” button on the right side.
    • As soon as you click this button, a form will appear.
    • Profile Settings-
      1. Profile Name- Enter the profile name.
      2. Configuration Method- Select the configuration method. Whether you want to want to create automatically create a MySQL superuser via SSH or manually enter an existing MySQL superuser’s credentials.
    • 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.
      2. Authentication Method- Choose the authentication method.
         1. If you select “Password” as the authentication method. Enter the password.
         2. 
         3. If you select “SSH Key” as the authentication method, then enter the SSH Key and SSH Key Passphrase.
         4.