How to change the root MySQL user password

Introduction

This article covers how to change the root MySQL user password. This may be required if you see errors like the following in cPanel or WHM.

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Procedure

The MySQL root user password can be updated in the WHM interface.

1. Login to WHM as root

2. Navigate to "Home » Database Services » Change Database Root Password"

3. Enter the new password in the text box or click "Password Generator"

4. When clicking "Password Generator," copy your password to a safe place, then click the checkbox to confirm you've done so.

5. Click "Use Password" to enter it into the Password box automatically

6. Finally, click "Change Password" to apply the change