These days hackers are EVERYWHERE! If you are ever unfortunate enough to have your site hacked and your Admin user account info changed by the hacker, the info below will help you regain access.
Please Note: You can ONLY do this if you are the site owner with access to your websites control panel. If for some reason you don’t know the details of your control panel login then contact your hosting provider.
Coppermine
Log into your cPanel/Control panel
Find the ‘Database’ section
Click on PHPMyAdmin
Select your Coppermine database from the list
Click on the Users table and then click on the ‘insert’ tab
Next step is to fill in the following fields to create your new user:
ID – Leave this field empty (it will automatically assign an ID)
user_group – Change this to 1 (which is for admin privileges)
user_active – Change this to yes
user_login – Insert the username you want to use
user_pass – Add a password for your account and then select MD5 (from the drop down menu)
user_email – Add the email address you want to use
user_email_valid – Change this to yes
Once finished with the above steps, click on ‘Go’
WordPress
Log into your cPanel/Control panel
Find the ‘Database’ section
Click on PHPMyAdmin
Select your WordPress database from the list
Click on the Users table and then click on the ‘insert’ tab
Next step is to fill in the following fields to create your new user:
ID – Leave this field empty (it will automatically assign an ID)
user_login – Insert the username you want to use
user_pass – Add a password for your account and then select MD5 (from the drop down menu)
user_nicename – You can leave this field empty for now
user_email – Add the email address you want to use
user_url – You can leave this field empty for now
user_registered – Select the date/time for when this user is registered
user_status – Set this to 0
display_name – You can leave this field empty for now
Once finished with the above steps, click on ‘Go’
You can then go back to the wp_users table and check the entries have been inserted correctly. Also, take note of the value in the ‘ID’ field. You will need this for the next step.
Final step:
Click on the ‘wp_usermeta’ and then click on the ‘insert’ tab
unmeta_id – Leave this field empty (it will automatically generate for you)
user_id – This is the ID of the user we created
meta_key – Enter wp_capabilities (or whatever yours is called – may not be wp_)
meta_value – Copy & Paste the below value
a:1:{s:13:"administrator";b:1;}
Once finished with the above steps, click on ‘Go’
Finished! You should now be able to login with your new account.