Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Apr 2018
    Posts
    30

    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
    32
    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
    110
    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.

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.