How to Create MySQL® Profiles via WHM?

MySQL profiles contain information for the connection to local or remote MySQL servers. In WHM, root users can create and manage new MySQL® profiles.

To Create MySQL® Profiles:

  1. Log in to your WHM root account.

  2. Select "SQL Services" from the menu.

https://www.milesweb.in/hosting-faqs/wp-content/uploads/2021/09/whm_sql_services-1024x467.png

  1. Select "Manage MySQL® Profiles."

https://www.milesweb.in/hosting-faqs/wp-content/uploads/2021/12/whm_manage_mysql_profiles-1024x301.png

The list of current MySQL® profiles will be displayed.

  1. Click on the "+Add Profile" button.

https://www.milesweb.in/hosting-faqs/wp-content/uploads/2021/12/whm_mysql_add_profile-1024x304.png

A form will display with the following fields:

  • Profile Name: Name for the MySQL profile

  • Configuration Method: Choose between automatic or manual creation of a MySQL superuser

  • Host: Insert the IP address or hostname of the MySQL server.

  • SSH Port: SSH server port

  • Username: Login user

  • Authentication Method: Opt for login via Password/SSH Key.

  • Password: Password for the profile (If Authentication Method is Password)

  • Escalation Method: Improve privileges for non-root users to access the MySQL superuser account.

  1. Enter the relevant details in the fields and click on "Save."

https://www.milesweb.in/hosting-faqs/wp-content/uploads/2021/12/whm_save_mysql_profile.png

The system will save the details and include the new profile in the list.

Utilize this method to create additional MySQL® profiles using WHM.

 


Was this article helpful?

mood_bad Dislike 0
mood Like 0
visibility Views: 296