How To Find Mysql Database User Password In Cpanel

In this article, we will see how to find MySQL database user password in Cpanel.

There are many ways to find the database user password in Cpanel, but we will describe one simple method. You can use this method on your own server or you can use it as a guide for others to use.

How To Find Mysql Database User Password In Cpanel

• redentials to cPanel along with appropriate permissions.

How to Change a MySQL Database User’s Password in cPanel

1. From your web browser, type https://youripaddress:2083 to get to the login screen. Replace the youripaddress portion with your actual IP address.  Enter your credentials and press Log in.

2. Under the Databases section, click the MySQL Databases icon.

3. Scroll down to the Current Users section. Locate the user whose password you want to change, and click Change Password.

4. Enter and confirm a new password, then click Change Password to save it.

5. A Success prompt appears. Click OK to continue back to the MySQL Databases page. The database user’s password is changed.

Wrapping Up

Adding the management of database users and their passwords to your security checklist is a must. With routine changes, you ensure your mission-critical data is protected.

Liquid Web customers with fully managed servers enjoy 24/7/365 support for their cPanel servers. They assist with the management while you focus on your site and core business. If you are interested in hosting with Liquid Web, contact our sales team to get started today.

how to find database username and password in phpmyadmin cpanel

Using phpMyAdmin from inside either the WHM interface or the cPanel interface will display a login screen instead of the phpMyAdmin interface.

 You will see a phpMyAdmin ‘Login’ screen when you navigate to the following location:

 WHM: Home -> SQL Services -> phpMyAdmin
 

Or you will see a phpMyAdmin ‘Login’ screen when you navigate to the following location:

 cPanel: Home -> Databases -> phpMyAdmin

Description

The login page can appear for phpMyAdmin when the MySQL password for either ‘root’ or the cPanel account is out of sync.

Workaround

To alleviate the issue, you would need to reset the password for MySQL, depending on which interface you see the ‘Login’ page on.

When using the WHM interface, do the following:

1. Log into WHM.

2. Navigate to the following location: WHM: Home -> SQL Services -> MySQL Root Password

3. Use the ‘Password Generator’ button to create a new secure password.
(This interface will NOT change the system root password, only the MySQL root password. We strongly recommended generating a new password.)

4. Copy the password somewhere safe.

5. Check the box for “I have copied this password in a safe place.”

6. Click “Use Password” button

7. Then click ‘Change Password’
The MySQL password is now changed, and you should now be able to use WHM phpMyAdmin.
When using the cPanel interface, do the following:

1. Log into cPanel as the affected account.

 

2. Navigate to the following location: cPanel: Home -> Preferences -> Password & Security

This will reset the cPanel account’s password. It is ok to reuse the previous password.
Also, you can use the ‘Password Generator’ button to create a new secure password.
screenshot

 

3. Click ‘Change your password now!” button

 

The account’s password is now reset, and you should be able to use cPanel phpMyAdmin.