Manage MySQL services through WHM

Manage MySQL services through WHM

In today’s blog we are going to discuss about MySQL Services in WHM/cPanel. It provides various tools for managing the MySQL databases on the server. You can also perform the various operations like how to manage MySQL user passwords, how to change the Root MySQL Password, and repair MySQL database through cPanel also. Today we will see how to perform these various operations through WHM. So first,

Step 1 – Log in to WHM.

• Manage MySQL user passwords in WHM

There is a feature in WHM that allows you to manage all the MySQL passwords on your system. This is useful because you don’t need to know an existing password to change it to a new one.

This tool will allow you to change the passwords used by any system programs that need a database, such as roundcube.

Step 1 – Go to the ‘SQL services’ menu.

Step 2 – Click ‘change MySQL User Password’.

Step 3 – Select the MySQL user from the list for system services. The username should reflect the application that uses it. Enter and confirm a new password or use the password guarantor. Click use password.

Step 4 – When finished click ‘Change Password’. A confirmation message will appear.

That’s it! The user’s password has been changed.

You should now know how to manage MySQL user passwords in WHM.

• How to change the Root MySQL Password

When cPanel/WHM is setup, your system MySQL password is randomly generated. If you ever need it you can change it to something you will know.

Step 1 – Go to ‘SQL Services’ in the WHM menu.

Step 2 – Click ‘MySQL Root Password’.

Since this password can be used to gain access to every database on your system, you should set this to something that is very hard to guess. Preferably, use the password generator.

Step 3 – Enter and confirm the new password or generate one. If you want you can change the password length to any other size. Take note of the password and store it in a safe place. Finally click ‘Change Password’. The Root MySQL password should have been changed successfully.

You now know how to change the root MySQL Password in WHM and How to reset it if necessary.

• How to Repair MySQL Database in WHM

Occasionally, a MySQL database can become corrupted.  This can be fixed from a number of places including cPanel, PHPMyAdmin as well as WHM.

Step 1 – Scroll down in the WHM menu to ‘SQL Services’.

Step 2 – Click ‘Repair a database’.

Step 3 – Select a database from the list.

Step 4 – Then click ‘Repair Database’.

That’s it! The database has been checked for problems and should have been repaired, if necessary.

You now know how to repair a MySQL databases in WHM.

Visit: Hostripples!