• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

WBXPress.NET

Website Developement Guide

  • apache2
  • nginx
  • mysql
  • php7
  • SSL
  • wordpress
  • genesis
  • caching
  • seo

Add Administrator of WordPress through MySQL

Updated on 15th October 2016 2 Comments

If you can not login to your wordpress site using administrator account in conventional methos, then you may create another administrator account. To create another account you need to execute the following mysql commands:

INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`, `user_registered`) VALUES ('newadmin', MD5('pass123'), 'firstname lastname', 'email@example.com', '0', '2016-10-10 00:00:00');

INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (Select max(id) FROM wp_users), 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');

INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (Select max(id) FROM wp_users), 'wp_user_level', '10');

Filed Under: mysql, troubleshooting, wordpress

Reader Interactions

Comments

  1. Sameer says

    4th November 2016 at 12:05 pm

    Awesome post, I would like to hide tags line on my blog I have ‘HIERO by aThemes’ installed on my blog. If you have any CSS code or other methods to hide the Post Tags which is showing in Homepage (after post) as well as inner post. Remember that I just want to hide Tags line not category (File Under). An earlier response will highly appreciated.

    Reply
    • wbxpress says

      13th November 2016 at 10:23 pm

      .entry-tags {
      display: none;
      }

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Most Popular Posts

  • Remove/ Defer Render-blocking JavaScripts
  • Customizing Genesis eleven40-pro Theme
  • Free Genesis Child Theme by WBXPress
  • Host Multiple Sites with SSL in Ubuntu 18.04
  • 25 Ways to Boost Website Traffic that Really Work

Recent Comments

  • Ruhul on Customizing Genesis eleven40-pro Theme
  • Priya Agarwal on Customizing Genesis eleven40-pro Theme
  • mimi roy on Remove/ Defer Render-blocking JavaScripts
  • danish choudhary on Customizing Genesis eleven40-pro Theme
  • Radhe on Customizing Genesis eleven40-pro Theme

Copyright © 2021 · Powered by WordPress · Log in