Step 1: <\/strong>Open the cPanel account Dashboard<\/p>\n\n\n\nStep 2:<\/strong> Navigate to phpMyAdmin in the Databases section.<\/p>\n\n\n\nStep 3:<\/strong> Click on phpMyAdmin.<\/p>\n\n\n\nStep 4: <\/strong>Once you’re on the phpMyAdmin dashboard, you need to select your WordPress database.<\/p>\n\n\n\nThis will open the WordPress database. You will be making changes to the wp_users and wp_usermeta tables.<\/strong><\/p>\n\n\n\nFirst, add a user to the wp_users table.<\/strong><\/p>\n\n\n\nStep 5<\/strong>: First, you need to navigate to the wp_users table and click on it. This will open the users currently listed in the table.<\/p>\n\n\n\nPlease note that there is one user ID in our demo website table 1. You need to add a new user using a new unique ID, so we’ll use the 2 numbers.<\/strong><\/p>\n\n\n\nStep 6:<\/strong> To create a new user, you need to click on the “Insert” tab.<\/p>\n\n\n\nStep 7:<\/strong> Add the following information to the fields on the Insert form:<\/p>\n\n\n\n\nID<\/strong>: pick a unique number (in our example, we\u2019ll use 2)<\/strong><\/li>\n\n\n\nuser_login<\/strong>: the username that will be used for login <\/strong><\/li>\n\n\n\nuser_pass<\/strong>: add a strong password, and make sure to select MD5 in the function from the drop-down menu (see the screenshot below)<\/strong><\/li>\n\n\n\nuser_nicename<\/strong>: the user\u2019s full name or nickname ( you can write according to yourself)<\/strong><\/li>\n\n\n\nuser_email<\/strong>: the user\u2019s email address<\/strong><\/li>\n\n\n\nuser_url<\/strong>: your website address<\/strong><\/li>\n\n\n\nuser_registered<\/strong>: select the date and time the user was registered using the calendar<\/strong><\/li>\n\n\n\nuser_activation_key<\/strong>: leave blank<\/strong><\/li>\n\n\n\nuser_status<\/strong>: set this to 0<\/strong><\/li>\n\n\n\ndisplay_name<\/strong>: the user\u2019s full name or display name<\/strong><\/li>\n<\/ul>\n\n\n\nStep 8:<\/strong> Once you have finished, click on the \u2018Go\u2019 button to add the new user.<\/p>\n\n\n\nNext adding a user to the wp_usermeta table<\/strong>.<\/p>\n\n\n\nStep 1: <\/strong>To add a new user, you need to navigate to wp_usermeta, click on it, and then click on the “insert” tab (same as the previous steps).<\/p>\n\n\n\nStep 2:<\/strong> Next, you need to add the following information to the Insert form:<\/p>\n\n\n\n\nunmeta_id<\/strong>: leave this blank <\/strong><\/li>\n\n\n\nuser_id<\/strong>: the user ID you used in the previous step<\/strong><\/li>\n\n\n\nmeta_key<\/strong>: this should be <\/strong>wp_capabilities<\/strong><\/li>\n\n\n\nmeta_value<\/strong>: insert this: <\/strong>a:1:{s:13:”administrator”;s:1:”1″;}<\/strong><\/li>\n<\/ul>\n\n\n\nStep 3:<\/strong> After that, you need to find fields for the second row.<\/p>\n\n\n\n\nunmeta_id<\/strong>: leave this blank <\/strong><\/li>\n\n\n\nuser_id<\/strong>: the user ID you used in the previous steps<\/strong><\/li>\n\n\n\nmeta_key<\/strong>: you need to enter <\/strong>wp_user_level<\/strong><\/li>\n\n\n\nmeta_value<\/strong>: 10<\/strong><\/li>\n<\/ul>\n\n\n\nStep 4:<\/strong> Once you finished typing the information into the fields, click the \u2018Go\u2019 button. that’s it. You Have successfully added new users.<\/p>\n\n\n\n<\/span>Conclusion <\/span><\/h2>\n\n\n\nAdding an Admin User to the WordPress Database With phpMyAdmin might seem daunting, but it’s a valuable skill to have in your arsenal. Make sure before any changes, you nedd to create backups, With these steps, you can easily add user in WordPress database <\/p>\n\n\n\n
<\/span>FAQ section on – Adding an Admin User to the WordPress Database With phpMyAdmin<\/span><\/h2>\n\n\n\n
\n
\n
<\/span>How do I add a user to my phpMyAdmin database?<\/span><\/h3>\n\n\n
The process involves the following steps:
\n
<\/span>What is phpMyAdmin, and why do I need it?<\/span><\/h3>\n\n\n
phpMyAdmin is a web-based interface used to manage MySQL databases. It’s a crucial tool for directly interacting with your WordPress Database to make changes that might not be possible through the WordPress dashboard.<\/p>\n\n<\/div>\n<\/div>\n
\n
<\/span>Why have I lost my administrator privileges in WordPress?<\/span><\/h3>\n\n\n
There can be various reasons for this issue, such as hacker has locked your website, you have lost access to the WordPress admin panel, or you have forgotten credentials<\/p>\n\n<\/div>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"
If you’re one of them facing a locked-out WordPress issue, hackers will hack and lock you out of your WordPress website by deleting WordPress administrator privileges. In this post, we’ll walk you through the steps of Adding an Admin User to the WordPress Database With phpMyAdmin Adding an Admin User to the WordPress Database With […]<\/p>\n","protected":false},"author":2,"featured_media":520,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[85],"tags":[115,105,116],"class_list":["post-528","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wordpress","tag-adding-an-admin-user-to-the-wordpress-database-with-phpmyadmin","tag-hostbet-shared-hosting","tag-phpmyadmin"],"_links":{"self":[{"href":"https:\/\/www.hostbet.in\/blog\/wp-json\/wp\/v2\/posts\/528"}],"collection":[{"href":"https:\/\/www.hostbet.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostbet.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostbet.in\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostbet.in\/blog\/wp-json\/wp\/v2\/comments?post=528"}],"version-history":[{"count":23,"href":"https:\/\/www.hostbet.in\/blog\/wp-json\/wp\/v2\/posts\/528\/revisions"}],"predecessor-version":[{"id":2618,"href":"https:\/\/www.hostbet.in\/blog\/wp-json\/wp\/v2\/posts\/528\/revisions\/2618"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hostbet.in\/blog\/wp-json\/wp\/v2\/media\/520"}],"wp:attachment":[{"href":"https:\/\/www.hostbet.in\/blog\/wp-json\/wp\/v2\/media?parent=528"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostbet.in\/blog\/wp-json\/wp\/v2\/categories?post=528"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostbet.in\/blog\/wp-json\/wp\/v2\/tags?post=528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}