How to change phpMyAdmin password?

October 24, 2022 46hotness 0likes 0comments

It is not surprising that some attackers who want to attack a website change the admin password and email address of an account. When this happens, it's not possible to reset your password the normal way because the reset link is being sent to the new email address assigned to the account. Don't worry, we're here to help. Just read this article and understand how to change root password in phpMyAdmin.

To fix this, you will need to go into your website database and change your password/email combination manually. There are two methods of changing the combination, the first one does not require any coding, while the second one requires a bit of MySQL but is faster.

Method 1: Edit PHPMyAdmin table

This method is the one I would recommend to anyone who hasn't had any experience with MySQL. It is relatively easy to understand and minimizes the risk of breaking your database.

Step 1
Find the PHPMyAdmin option in your cPanel or the hosting control panel you have.

Step 2
Search the database that corresponds to the website you want to visit. For more popular frameworks like WordPress, your database should start with _wp, followed by a group of numbers. If you have created a custom name for your database then select it.

Screenshot 56

Step 3

Navigate to the wp_users tab and select it. Find the password of the user you want to change and click the “edit” button to the left of the username.

Screenshot 57

Step 4
In the user_pass section, change the function to MD5 and enter the new password in the Value column. If necessary, you can also change the email address in the email section.

Screenshot 58

When you are satisfied with the values ​​you entered, save the new values ​​by clicking the start button at the bottom of the page.

Screenshot 59

Method 2: Using MySQL Query

I recommend you to use this method only if you have some mysql coding experience. The only real difference between the two is how much you want to feel like a hacker attacking in front of your colleagues.

Step 1
Find the PHPMyAdmin option in your cPanel or the hosting control panel you have.

Step 2
Search the database that corresponds to the website you want to visit. For more popular frameworks like WordPress, your database should start with _wp, followed by a group of numbers. If you have created a custom name for your database then select it.

Navigate to the wp_users tab and select it. Find the password of the user you want to change and click the “edit” button to the left of the username.

Screenshot 57

Step 3

Select the SQL or MySQL tab above the table structure.

Screenshot 60

Step 4

Enter the following code:
UPDATE `wp_users` SET `user_pass`= MD5(‘yourpassword’) WHERE `user_login`=’yourusername’;
Replace “your password” with the password you will use to log in and replace “username” with your WordPress username.

Screenshot 61

Step 5

When you are satisfied with the values ​​you entered, save the new values ​​by clicking the start button at the bottom of the page.

Screenshot 59

Wishing you success!
If during the implementation process there is an error or problem, you can contact the technical department for help. Currently, BKHOST has the following contact ways:
• Contact via call center 024 7303 8088, then press 2 to meet BPKT.
• Submit tickets through website manage.hostagy.vn.
• Live chat directly on hostagy.vn homepage.
• Remote support via TeamView or Ultraview.

hostadmin

This person is a lazy dog and has left nothing

Comments