How to Log in to hPanel
Posted: Tue Feb 11, 2025 9:07 am
Scroll down and locate the database section, select phpMyAdmin
Once you are logged in, click on phpMyAdmin and you will be redirected to the admin page. Select Structure, and scroll down to find wp_users.
When you click on wp_users , you will see your user site login information on the next page. Select Edit.
Then, simply enter the new password in the user_pass column to change it. Make other changes as needed.
Before pressing the Go button to save the changes, change the Function value of the password to MD5 . It is used to encrypt your password for some extra layer of security.
3. Loss of administrator privileges
In some cases, you may find yourself losing access to your WordPress australia whatsapp data admin area, unable to log in, or your username does not exist. This can happen for a few reasons: The site owner revokes your admin rights, or you may be the victim of a hack.
How to fix:
If so, you will need to add a new administrator user to your Wordpress database directly via phpMyAdmin. Here's how:
Log in to hPanel and open phpMyAdmin
Once you are on the admin page, click on wp_users , and then select Insert.
Fill in the columns as needed and save the changes. Select an unused ID number in the database and keep the user_status equal to 0.
Once you have saved your changes, navigate to the left side of the screen and select the wp_usersmeta table , then find Insert.
Fill in the following information columns:
unmeta_id – Leave blank as it will be auto generated
user_id – Enter the ID number you inserted in step three
meta_key – Enter in wp_capabilities
meta_value – Add a:1:{s:13:”administrator”;b:1;}
Once you are logged in, click on phpMyAdmin and you will be redirected to the admin page. Select Structure, and scroll down to find wp_users.
When you click on wp_users , you will see your user site login information on the next page. Select Edit.
Then, simply enter the new password in the user_pass column to change it. Make other changes as needed.
Before pressing the Go button to save the changes, change the Function value of the password to MD5 . It is used to encrypt your password for some extra layer of security.
3. Loss of administrator privileges
In some cases, you may find yourself losing access to your WordPress australia whatsapp data admin area, unable to log in, or your username does not exist. This can happen for a few reasons: The site owner revokes your admin rights, or you may be the victim of a hack.
How to fix:
If so, you will need to add a new administrator user to your Wordpress database directly via phpMyAdmin. Here's how:
Log in to hPanel and open phpMyAdmin
Once you are on the admin page, click on wp_users , and then select Insert.
Fill in the columns as needed and save the changes. Select an unused ID number in the database and keep the user_status equal to 0.
Once you have saved your changes, navigate to the left side of the screen and select the wp_usersmeta table , then find Insert.
Fill in the following information columns:
unmeta_id – Leave blank as it will be auto generated
user_id – Enter the ID number you inserted in step three
meta_key – Enter in wp_capabilities
meta_value – Add a:1:{s:13:”administrator”;b:1;}