{"id":26712,"date":"2019-10-03T14:31:33","date_gmt":"2019-10-03T06:31:33","guid":{"rendered":"https:\/\/tanyadigital.com\/?p=26712"},"modified":"2019-10-03T14:53:16","modified_gmt":"2019-10-03T06:53:16","slug":"how-to-change-website-backend-password-via-phpmyadmin-mysql-database","status":"publish","type":"post","link":"https:\/\/tanyadigital.com\/en\/how-to-change-website-backend-password-via-phpmyadmin-mysql-database\/","title":{"rendered":"How to Change Website Backend Password via phpMyadmin Mysql Database"},"content":{"rendered":"
Creating a website is fun especially having coding skills; there are many ways to create a website using many open source CMS like Joomla, WordPress, and for eCommerce websites, you can use Magento, Woocommerce, Opencart, Prestashop and other ecommerce cms.<\/p>
There are steps to create a website by uploading files and setting a backend page password like WordPress, wp-admin. Sometimes when we create a website and sometimes there are things that we don’t want, like forgetting your password or your website has a hacker attack that changes the backend password.<\/p>
For that, I give a solution for you to change it through phpMyadmin. This method is usually used to backup passwords to reset passwords directly from the database through cPanel (Control Panel).<\/p>
The steps that you must take:<\/p>
1. First generate a password via MD5 Hash Password on the website:<\/p>
2. Enter the password as you wish<\/p>
3. Enter Cpanel and click PhpMyadmin<\/p>
4. Search for a database that matches your website<\/p>
5. After entering the database, look for the position of user admin \/ administrator: there we see our IDs and passwords encrypted with MD5<\/p>
6. The next step is to replace the MD5 password with a new MD5 password that has just been generated via https:\/\/www.md5online.org\/<\/p>
7. Next save<\/p>
8. Back to Backed Admin Your website and please log in according to your admin id and enter the Decryption password from MD5<\/p>
9. Enjoy<\/p>
Good luck<\/p>","protected":false},"excerpt":{"rendered":"
Creating a website is fun especially having coding skills; there are many ways to create a website using many open source CMS like Joomla, WordPress, and for eCommerce websites, you can use Magento, Woocommerce, Opencart, Prestashop and other ecommerce cms. There are steps to create a website by uploading files and setting a backend page […]<\/p>\n","protected":false},"author":1,"featured_media":26718,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[68],"tags":[],"class_list":["post-26712","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-internet-security"],"yoast_head":"\n