How to reset the password for a MySQL database?

You may need to change the password of your database in order to improve the security of your website or if your account has been compromised by hackers. Basically the easiest way to change the password for your database is to recreate the MySQL user attached to it. You can use the following instructions to do so:

    Log in your cPanel -> MySQL Databases. Find the corresponding database and see which is the user attached to it. For example we will consider that your database is called yourusername_database and the database user attached to it is yourusername_user.

    Scroll to the bottom of the page and you will see a field called Current Users. There is a little circle with X in it – press it to delete the database user yourusername_user.

You will be prompted to confirm this action:

Are you sure you wish to permanently remove user yourusername_user?

Click on the Delete User button in order for the database user to be successfully deleted.

Then you should create a new database user:

    Go back to cPanel -> MySQL Databases and create a new user:

Type the same database username and type (or generate) the new password for it. Bear in mind that you will be able to change only the user part of the database name yourusername_user. The prefix yourusername_ is added by default by the system.

    When the MySQL user is created you have to attach it to your database/s. On the same page you will find a section called Add User To Database – just assign the database user to the desired database/s and grant all privileges for it.

NB: Note that if the database is used by a script/web application (WordPress, Joomla etc.) you will have to reconfigure it and set the new password inside its configuration file. If you are not certain how to do this, you can open a new ticket to support department and we will gladly assist you with the re-configuration.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What type of databases do you support? PGSQL and MySQL?

All our servers support MySQL and PostgreSQL databases. Also with any of our hosting packages...

How to repair a MySQL database?

In this article we will show you two ways to repair a MySQL database.  1) Through...

How to optimize a MySQL database using phpMyAdmin?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this...

How to change the database engine of a MySQL database table?

In this article we will show you how to change the database engine of a MySQL table. Let's...

I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database

In order to solve this issue follow these steps: Open the MySQL dump with a text editor on...