{"id":39188,"date":"2015-02-02T05:05:44","date_gmt":"2015-02-02T10:05:44","guid":{"rendered":"http:\/\/www.templatemonster.com\/help\/?p=39188"},"modified":"2017-07-14T06:02:07","modified_gmt":"2017-07-14T10:02:07","slug":"wordpress-create-new-admin-user-via-database","status":"publish","type":"post","link":"https:\/\/www.templatemonster.com\/help\/wordpress-create-new-admin-user-via-database.html","title":{"rendered":"WordPress. How to create new admin user via database"},"content":{"rendered":"<p>\r\n<\/p>\r\n<p>Hello! This tutorial will show you how to create new admin user via database.<\/p>\r\n<p><a href=\"http:\/\/www.youtube.com\/watch?v=7sVagJZ8_68?width=1280&amp;height=720\" rel=\"prettyPhoto\">WordPress. How to create new admin user via database<\/a><\/p>\r\n<p class=\"warning\">Note: You should always make a <a href=\"\/help\/phpmyadmin-how-to-backup-a-database.html\" target=\"_blank\">backup<\/a> of your database before performing any MySQL edits.<\/p>\r\n<p>In order to create<strong> new admin user via database<\/strong>, you should perform the following steps:<\/p>\r\n<ol>\r\n<li>\r\n<p>Log into <strong>phpMyAdmin<\/strong> section on your hosting control panel and locate your <strong>WordPress database<\/strong>:<\/p>\r\n<p><a href=\"\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-1.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-1-300x117.png\" alt=\"WordPress._How_to_create_new_admin_user_via_database-1\" width=\"300\" height=\"117\" class=\"aligncenter size-medium wp-image-39189\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-1-300x117.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-1-150x58.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-1.png 1021w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\r\n<\/li>\r\n<li>\r\n<p>Click on <strong>wp_users table<\/strong>. We need to insert our new admin user\u2019s information, so click on the <strong>Insert tab<\/strong>:<\/p>\r\n<p><a href=\"\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-2.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-2-300x119.png\" alt=\"WordPress._How_to_create_new_admin_user_via_database-2\" width=\"300\" height=\"119\" class=\"aligncenter size-medium wp-image-39190\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-2-300x119.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-2-150x59.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-2.png 980w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\r\n<p> In the insert form, add the following:<\/p>\r\n<ul class=\"list\">\r\n<li><strong>ID<\/strong> \u2013 pick a number (in our example, we will use number 4).<\/li>\r\n<li><strong>user_login <\/strong>\u2013 insert the username you want to use to access the WordPress Dashboard.<\/li>\r\n<li><strong>user_pass<\/strong> \u2013 add a password for this username. Make sure to select MD5 in the functions menu (Refer to the screenshot below).<\/li>\r\n<li><strong>user_nicename<\/strong> \u2013 put a nickname or any &#8220;nice&#8221; name for this admin user.<\/li>\r\n<li><strong>user_email<\/strong> \u2013 add the email you want to associate with this account.<\/li>\r\n<li><strong>user_url<\/strong> \u2013 this would be the URL to your website.<\/li>\r\n<li><strong>user_registered<\/strong> \u2013 select the date\/time for when this user is registered.<\/li>\r\n<li><strong>user_status<\/strong> \u2013 set this to 0.<\/li>\r\n<li><strong>display_name<\/strong>\u2013 put the name you like to display for this user on the site (it can be your user_nicename value as well).<\/li>\r\n<li>Click on the<strong> Go Button<\/strong>:<\/li>\r\n<\/ul>\r\n<p><a href=\"\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-3.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-3-300x118.png\" alt=\"WordPress._How_to_create_new_admin_user_via_database-3\" width=\"300\" height=\"118\" class=\"aligncenter size-medium wp-image-39191\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-3-300x118.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-3-150x59.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-3.png 977w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\r\n<\/li>\r\n<div class=\"inline-banner\">\r\n<a href=\"https:\/\/www.templatemonster.com\/service-center\/\">\r\n<img src=\"\/help\/files\/banners\/inline\/Banner-3-(835-x100).jpg\" \/>\r\n<\/a>\r\n<\/div>\r\n<li>\r\n<p>Next, we have to add the values to<strong> wp_usermeta table<\/strong>. Click on the<strong> wp_usermeta table<\/strong> and then click on the<strong> Insert tab<\/strong> like in the previous step: <\/p>\r\n<p><a href=\"\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-4.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-4-300x114.png\" alt=\"WordPress._How_to_create_new_admin_user_via_database-4\" width=\"300\" height=\"114\" class=\"aligncenter size-medium wp-image-39192\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-4-300x114.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-4-150x57.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-4.png 899w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\r\n<p>Then add the following information to the <strong>insert form:<\/strong><\/p>\r\n<ul class=\"list\">\r\n<li><strong>unmeta_id<\/strong> \u2013 leave this blank (it will be auto-generated).<\/li>\r\n<li><strong>user_id<\/strong> \u2013 this will be the id of the user you created in the previous step. Remember we picked 4.<\/li>\r\n<li><strong>meta_key <\/strong>\u2013 this should be wp_capabilities.<\/li>\r\n<li><strong>meta_value<\/strong> \u2013 insert this: a:1:{s:13:&#8221;administrator&#8221;;s:1:&#8221;1&#8243;;}<\/li>\r\n<\/ul>\r\n<p><strong>Insert another row<\/strong> with the following information:<\/p>\r\n<ul>\r\n<li><strong>unmeta_id <\/strong>\u2013 leave this blank (it will be auto-generated).<\/li>\r\n<li><strong>user_id <\/strong>\u2013 this will be the id of the user you created in the previous step. Remember we picked 4.<\/li>\r\n<li><strong>meta_key<\/strong> \u2013 this should be wp_user_level<\/li>\r\n<li><strong>meta_value<\/strong> \u2013 10.<\/li>\r\n<li>Then click on <strong> Go button<\/strong>:<\/li>\r\n<\/ul>\r\n<p><a href=\"\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-5.png\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-5-300x221.png\" alt=\"WordPress._How_to_create_new_admin_user_via_database-5\" width=\"300\" height=\"221\" class=\"aligncenter size-medium wp-image-39193\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-5-300x221.png 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-5-150x110.png 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/10\/WordPress._How_to_create_new_admin_user_via_database-5.png 899w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\r\n<\/li>\r\n<\/ol>\r\n<p>Now you will be able to log into your WordPress dashboard with the username and password you specified for this user.<\/p>\r\n<p>Feel free to check the detailed video tutorial below:<\/p>\r\n<p><a href=\"http:\/\/www.youtube.com\/watch?v=7sVagJZ8_68?width=1280&amp;height=720\" rel=\"prettyPhoto\">WordPress. How to create new admin user via database<\/a><\/p>\r\n<\/p>\r\n<p><\/p>","protected":false},"excerpt":{"rendered":"<p>This tutorial will show you how to create new admin user via database in Wordpress.<\/p>\n","protected":false},"author":71,"featured_media":43472,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[728],"tags":[582,796,545,883,2405],"_links":{"self":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/39188"}],"collection":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/users\/71"}],"replies":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/comments?post=39188"}],"version-history":[{"count":2,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/39188\/revisions"}],"predecessor-version":[{"id":82024,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/39188\/revisions\/82024"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media\/43472"}],"wp:attachment":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media?parent=39188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/categories?post=39188"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/tags?post=39188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}