المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : ووردبريس wordpress تغيير الباسورد Change Password من MySQL / PHPMyAdmin



Rise Company
12-09-2019, 11:17
ووردبريس wordpress تغيير الباسورد Change Password من MySQL / PHPMyAdmin
Change / Reset WordPress password using MySQL / PHPMyAdmin

https://www.rise.company/upload/uploads/156827990325371.png

##############################################
Method#1 – The Long way through PHPMyAdmin table editing
##############################################

This method involves editing and updating the wp_users table values to reset our lost WordPress password. The method is little longer but is also easy enough to follow without knowing technical things.
Head over to PHPMyAdmin using your cPanel (or the hosting panel that your hosting service supports).
Click on your WordPress database.

https://www.rise.company/forum/images/imported/2019/09/16.jpg

Navigate to and click the table wp_users.

https://www.rise.company/forum/images/imported/2019/09/17.jpg

Edit the row with your WordPress username.

https://www.rise.company/forum/images/imported/2019/09/18.jpg

Now, in the user_pass field, change the function to MD5 and enter your new password in the Value section (refer below screenshot).

https://www.rise.company/forum/images/imported/2019/09/19.jpg

Click “Go” or similar option at the bottom to update the table values.
https://www.rise.company/forum/images/imported/2019/09/20.jpg

##############################################

Method#2 – The Short way through MySQL
##############################################

This methods implements the direct SQL query execution to update the wp_users table value to reset our hacked WordPress password.
Follow the first 3 steps of the above method.
Go to SQL or MySQL section in your PHPMyAdmin.

https://www.rise.company/forum/images/imported/2019/09/21.jpg

Now, enter the below given query:

UPDATE `wp_users` SET `user_pass`= MD5('yourpassword') WHERE `user_login`='yourusername';
Put your new password in place of yourpassword and replace yourusername with your WordPress username.

https://www.rise.company/forum/images/imported/2019/09/22.jpg


Click “Go” or similar option at the bottom to execute the query.