How do I get access to a MySQL database if I have lost the user password?

September 11, 2017     0 comments

You must create a new MySQL user with a new password. Do not worry, this will not erase or change any of the data in your database. To do so please follow the steps below:

  1. Login to your cPanel, under the Databases heading click MySQL Databases
  2. Create a new MySQL user with the desired password
  3. If you wish to, delete the user that you have lost the password
  4. Add the new user to your database and grant it All Privileges
  5. Update your MySQL configuration file

Here is the video tutorial to create new MySQL user and database in Cpanel.

How helpful was this article to you?

Leave a comment

Your name
Your email address
Comment on this article
Powered by