How to Change MySQL User Password via WHM Root?

Introduction

The security of MySQL databases requires users to regularly change their passwords. If you're using WHM (Web Host Manager), there are a few simple steps to change a MySQL user password. In this article, we will guide you through the process of changing a MySQL user password through WHM, step by step.

Step 1: Log in to WHM as Root

The first step in changing a MySQL user password is to log in to WHM as the root user. Root access means you have the highest level of privileges on the system.

1. Log in to your WHM account.
2. After logging in with your username and password, you will access the WHM main control panel.

Step 2: Navigate to "SQL Services"

Now, you need to navigate to the "SQL Services" section to change the MySQL user password.

1. In the WHM main panel, click on "SQL Services" from the left-hand menu.

Step 3: Select "Change MySQL User Password"

In the "SQL Services" section, click on "Change MySQL User Password" to proceed.

Step 4: Choose the User

Next, you need to select the user for whom you want to change the password from a dropdown menu. Choose the relevant user.

Step 5: Enter the Password

Now, to set a new password, you need to enter the desired password in both text boxes. Using a strong and unique password is essential for security.

1. Enter the new password in both boxes.

Step 6: Click on "Change Password"

The final step is to click on the "Change Password" button to save the new password. The new password will be effective for the selected user.

1. Click on the "Change Password" button.

You have now successfully changed the MySQL user password! This is an important step to enhance the security of your database, and it's recommended to update your password at regular intervals.