< All Topics

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.Manage MySQL® Profile
      • You will find previously added MySQL profiles.Manage MySQL® Profile
      • Click on the “+Add Profile” button on the right side.Manage MySQL® Profile
      • 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. Manage MySQL® Profile
          3. If you select “SSH Key” as the authentication method, then enter the SSH Key and SSH Key Passphrase.
          4. Manage MySQL® Profile