Change WordPress Database User Password via CPanel

This aim of this weblog submit is to point out WordPress learners easy methods to change the database consumer password. When you don’t keep in mind the password of the database consumer account, the one choice is to create a brand new consumer account or change the password for the present account.
You might not have to do that as soon as WordPress is setup and dealing. The solely cause you’ll have to mess with WordPress configuration file, (wp-config.php) is if you delete, modify or mess with it. As lengthy as your weblog is functioning, there’s no want to the touch this configuration file.

Now, when that day comes and WordPress config file is not obtainable or has been modified, you then’ll have to go and redo the configuration. Without specifying the database identify, database username and password, WordPress won’t work.

This temporary tutorial goes to point out you methods to discover  and alter the database consumer password for those who can’t keep in mind it.

Here’s what occurred to me a very long time in the past.

I had simply put in my first WordPress site and every little thing appears to be working simply high-quality.. till I determined to go and edit the wp-config.php file.

 

I made all of the modifications I needed to make and save the file. When I tried to entry my weblog and acquired a message that WordPress can’t hook up with the database.

Some type of database connection error. I went again to the file and verified every little thing. I quickly realized that the password I typed is perhaps totally different than what was created for the database consumer.

It turned out that I had forgotten it. Didn’t realize it and was caught. The solely method round this was to reset the database consumer password.

When you’re utilizing CPanel as your host device, all it’s essential to do is go to MySQL Databases as proven under and choose the username you want to reset the password.

 

mysql-password-reset

 

At the underside of the web page you’ll see present customers. Select to account you want to change the password.

 

mysql-password-reset-1

 

Then sort and ensure the brand new password and reserve it by clicking the Change Password button. This is how you modify a MySQL database consumer password.

 

mysql-password-reset-2

 

Next, return to the wp-config.php file and sort the right password for the account. When you’re carried out, save the file and check out connecting to your website once more.

Hopefully this time it is going to work.

That simply what I didn’t when I forgot the password of the database consumer for WordPress.

Leave a Reply