This guide explains how to activate a MySQL profile in WHM. A profile stores the connection details for a database server; activating it changes which server WHM uses for database administration and new databases.
Before you start
You need administrator access to WHM and a configured, working MySQL profile.
Activating a profile does not move existing databases or update website connection settings. Plan any database migration separately, keep backups and check the effect on existing applications before changing the active server.
Validate and activate the profile
-
Open SQL Services > Manage MySQL Profiles in WHM.
-
Find the intended profile and use Validate to check its connection. Resolve any validation errors before continuing.
-
Select Activate for that profile.
-
Review the confirmation, then select Continue if the profile and server are correct.
Confirm the active profile
Check the success message and the active-profile indicator, shown as a green lightning bolt in the illustrated interface. Confirm that the expected server is now active and test any affected database administration tasks.
