Results 1 to 5 of 5
  1. #1
    Member
    Join Date
    Apr 2018
    Posts
    31

    Lightbulb How to add a new Wordpress Admininstrator user using phpMyAdmin?

    You can create a new database administrator user in wordpress sites using phpMyadmin by issuing the following three Database Queries.

    After running these queries, you can login to your worpress admin with the following login details.
    UserName: admin1
    Password: admin1


    Query1:

    INSERT INTO `databasename`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`)
    VALUES ('4', 'admin1', MD5('admin1'), 'Admin', 'admin@yourdomain.com', 'http://www.yourdomain.com/', '2012-12-30 00:00:00', '', '0', 'Admin');

    Query2:

    INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)
    VALUES (NULL, '4', 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}');

    Query3:

    INSERT INTO `databasename`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)
    VALUES (NULL, '4', 'wp_user_level', '10');


    Note:- Please don't forget to change the 'databasename' with the database you are working with.
    Please read through all the fields in the tables and change the values as you wish.

  2. #2
    Registered User
    Join Date
    Apr 2018
    Posts
    118
    Here are the steps you will need to follow to give your user privileges.
    Click on the wp_usermeta table to bring up the entries.
    Click on the “Insert” tab to insert a new row.
    Fill in the following information. ...
    Insert another row with this information. ...
    Click the “Go” button in phpMyAdmin to insert the row.

  3. #3
    Senior Member
    Join Date
    May 2018
    Posts
    155
    Why can't we just add it through dashboard ? Again, it is not good to have more than one administrator. Better give the option as an editor to other users.

  4. #4
    Senior Member
    Join Date
    May 2015
    Location
    UK
    Posts
    260
    To begin, log into your cPanel interface
    From the main cPanel screen, find the Databases category and click on the icon entitled phpMyAdmin
    Once the first screen appears, look to the left hand sidebar and click on the database for your specific WordPress installation. If you do not know which database is the correct one, you can find out by using these instructions
    After the database information loads, you will need to find the tab named SQL and click on it
    This leads you to an SQL editor where you will enter some code that will create a new admin account for you
    After replacing any data fields you need, click the Go button to perform the insertion
    This should simply refresh the screen and you should see the messsage '1 row affected' after each of the three SQL statements. This means the insertion ran smoothly. From here, visit your wordpress admin login area as normal and use the new admin login information. You should get to the admin interface without issue

  5. #5
    Junior Member
    Join Date
    May 2018
    Posts
    4
    why do you want to do this ? just go to Admin panel and add a new Admin its simple

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

  Find Web Hosting      
  Shared Web Hosting UNIX & Linux Web Hosting Windows Web Hosting Adult Web Hosting
  ASP ASP.NET Web Hosting Reseller Web Hosting VPS Web Hosting Managed Web Hosting
  Cloud Web Hosting Dedicated Server E-commerce Web Hosting Cheap Web Hosting


Premium Partners:


Visit forums.thewebhostbiz.com: to discuss the web hosting business, buy and sell websites and domain names, and discuss current web hosting tools and software.