0057.jpg
0056.jpg
0055.jpg
0054.jpg
0052.jpg
0053.jpg
0051.jpg
0021.jpg
Please feel free to visit my Portfolio and check out some of my previous designs.
Create an Admin User for WordPress or Coppermine via MySQL (PHPMyAdmin)

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.



      Posted by admin   September 14th, 2019
    Search
    Advertisement
    Testimonials
    Affiliates
    Channing-tatum.netShemar-moore.net

    CURRENTLY ACCEPTING APPLY | VIEW
    Site Statistics
    • Gemma
    • Established in 2010

    I never intend to infringe on the rights of others. I create my designs on the understanding that the client has obtained appropriate license or permission to use the photos. If you find something you feel is infringing on your rights, please contact me before pursuing any legal action and I will gladly accommodate your request and remove the infringing item in question.