{"id":13245,"date":"2026-06-16T08:59:30","date_gmt":"2026-06-16T08:59:30","guid":{"rendered":"https:\/\/www.webystrata.com\/blog\/?p=13245"},"modified":"2026-06-16T08:59:30","modified_gmt":"2026-06-16T08:59:30","slug":"add-admin-user-to-wordpress-database-from-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.webystrata.com\/blog\/add-admin-user-to-wordpress-database-from-phpmyadmin\/","title":{"rendered":"How to Add  Admin User to WordPress Database from phpMyAdmin"},"content":{"rendered":"<h1>How to Add Admin User to\u00a0 WordPress Database from phpMyAdmin<\/h1>\n<p>WordPress administrators occasionally face situations where they are unable to access the dashboard due to forgotten credentials, deleted administrator accounts, plugin conflicts, or security issues. When traditional password recovery methods fail, phpMyAdmin provides a reliable way to create a new administrator account directly from the WordPress database.<\/p>\n<p>By adding a new user record to the database and assigning administrator privileges, you can quickly regain full control of your website without modifying existing accounts. In this guide, you&#8217;ll learn how to add an admin user to the WordPress database using phpMyAdmin.<\/p>\n<h2>Prerequisites<\/h2>\n<p>Before proceeding, ensure that you have:<\/p>\n<ul>\n<li>Access to your hosting control panel.<\/li>\n<li>Access to phpMyAdmin.<\/li>\n<li>Knowledge of the WordPress database being used by your website.<\/li>\n<li>Backup of your database before making changes.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3 data-section-id=\"1xfbx8e\" data-start=\"0\" data-end=\"98\">Step 1: Login to cPanel from WebyStrata Client Area<\/h3>\n<p data-start=\"446\" data-end=\"570\">First, visit the WebyStrata website and log in to your client area account using your registered email address and password.<\/p>\n<p data-start=\"446\" data-end=\"570\">official Website <a href=\"https:\/\/www.webystrata.com\">www.webystrata.com<\/a><\/p>\n<p data-start=\"291\" data-end=\"308\"><span style=\"color: #000000;\">After logging in:<\/span><\/p>\n<ol data-start=\"310\" data-end=\"429\">\n<li data-section-id=\"ygoy3r\" data-start=\"310\" data-end=\"331\"><span style=\"color: #000000;\">Go to <strong data-start=\"319\" data-end=\"331\">Services<\/strong><\/span><\/li>\n<li data-section-id=\"wyqca4\" data-start=\"332\" data-end=\"359\"><span style=\"color: #000000;\">Click on <strong data-start=\"344\" data-end=\"359\">My Services<\/strong><\/span><\/li>\n<li data-section-id=\"8kxumo\" data-start=\"360\" data-end=\"397\"><span style=\"color: #000000;\">Select your active hosting service<\/span><\/li>\n<li data-section-id=\"4ekbul\" data-start=\"398\" data-end=\"429\"><span style=\"color: #000000;\">Click on <strong data-start=\"410\" data-end=\"429\">Login to cPanel<\/strong><\/span><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-13246\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/login-into-cpanel-9.webp\" alt=\"how-to-add-admin user-to-wordpress-database-from-phpmyadmin\" width=\"1902\" height=\"957\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/login-into-cpanel-9.webp 1902w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/login-into-cpanel-9-300x151.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/login-into-cpanel-9-1024x515.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/login-into-cpanel-9-768x386.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/login-into-cpanel-9-1536x773.webp 1536w\" sizes=\"(max-width: 1902px) 100vw, 1902px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>\u00a0Navigate to the <strong>Databases<\/strong> section. Click <strong>phpMyAdmin<\/strong> to launch the database management interface.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-13247\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/db-php-3.webp\" alt=\"how-to-add-admin user-to-wordpress-database-from-phpmyadmin\" width=\"1918\" height=\"911\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/db-php-3.webp 1918w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/db-php-3-300x142.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/db-php-3-1024x486.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/db-php-3-768x365.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/db-php-3-1536x730.webp 1536w\" sizes=\"(max-width: 1918px) 100vw, 1918px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>From the left-hand menu, select the WordPress database associated with your website.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-13248\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/database.webp\" alt=\"how-to-add-admin user-to-wordpress-database-from-phpmyadmin\" width=\"1917\" height=\"906\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/database.webp 1917w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/database-300x142.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/database-1024x484.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/database-768x363.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/database-1536x726.webp 1536w\" sizes=\"(max-width: 1917px) 100vw, 1917px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>If you are unsure which database WordPress uses, check the <code>wp-config.php<\/code> file located in your WordPress installation directory.<\/p>\n<h2>Step 2: Create a New User<\/h2>\n<p>Locate the <strong>databasename_users<\/strong> table. In most WordPress installations, this table is named <strong>wp_users<\/strong>, although the prefix may differ depending on your configuration.<\/p>\n<ul>\n<li>Click the table and then select the <strong>Insert<\/strong> tab.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13249\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/user-insert.webp\" alt=\"how-to-add-admin user-to-wordpress-database-from-phpmyadmin\" width=\"1917\" height=\"912\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/user-insert.webp 1917w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/user-insert-300x143.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/user-insert-1024x487.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/user-insert-768x365.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/user-insert-1536x731.webp 1536w\" sizes=\"(max-width: 1917px) 100vw, 1917px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Enter the following information:<\/p>\n<ul>\n<li><strong>user_login:<\/strong> Enter the username for the new administrator account.<\/li>\n<li><strong>user_pass:<\/strong> Enter a password and select <strong>MD5<\/strong> from the Function dropdown menu.<\/li>\n<li><strong>user_nicename:<\/strong> Enter a nickname for the user.<\/li>\n<li><strong>user_email:<\/strong> Enter a valid email address.<\/li>\n<li><strong>user_registered:<\/strong> Enter the current date and time.<\/li>\n<li><strong>display_name:<\/strong> Enter the display name that will appear within WordPress.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13250\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/db-details1.webp\" alt=\"how-to-add-admin user-to-wordpress-database-from-phpmyadmin\" width=\"1913\" height=\"907\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/db-details1.webp 1913w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/db-details1-300x142.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/db-details1-1024x486.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/db-details1-768x364.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/db-details1-1536x728.webp 1536w\" sizes=\"(max-width: 1913px) 100vw, 1913px\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>After filling in the required fields, click <strong>Go<\/strong> to save the new user record.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13251\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go1-1.webp\" alt=\"how-to-add-admin user-to-wordpress-database-from-phpmyadmin\" width=\"1918\" height=\"900\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go1-1.webp 1918w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go1-1-300x141.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go1-1-1024x481.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go1-1-768x360.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go1-1-1536x721.webp 1536w\" sizes=\"(max-width: 1918px) 100vw, 1918px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>Step 3: Find the User ID<\/h2>\n<p>Return to the <strong>databasename_users<\/strong> table and locate the newly created user.<\/p>\n<p>Make a note of the <strong>ID<\/strong> assigned to the user. This value is important because it will be used when assigning administrator privileges in the next steps.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13252\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/step3.webp\" alt=\"how-to-add-admin user-to-wordpress-database-from-phpmyadmin\" width=\"1917\" height=\"906\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/step3.webp 1917w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/step3-300x142.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/step3-1024x484.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/step3-768x363.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/step3-1536x726.webp 1536w\" sizes=\"(max-width: 1917px) 100vw, 1917px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>Step 4: Assign Administrator Capabilities<\/h2>\n<p>Next, locate and open the <strong>databasename_usermeta<\/strong> table.<\/p>\n<ul>\n<li>Click the <strong>Insert<\/strong> tab<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13253\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/usermeta-insert.webp\" alt=\"how-to-add-admin user-to-wordpress-database-from-phpmyadmin\" width=\"1913\" height=\"906\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/usermeta-insert.webp 1913w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/usermeta-insert-300x142.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/usermeta-insert-1024x485.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/usermeta-insert-768x364.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/usermeta-insert-1536x727.webp 1536w\" sizes=\"(max-width: 1913px) 100vw, 1913px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Enter the following information:<\/p>\n<ul>\n<li><strong>user_id:<\/strong> Enter the ID of the user created in the previous step.<\/li>\n<li><strong>meta_key:<\/strong> Enter <code>databasename_capabilities<\/code>.<\/li>\n<li><strong>meta_value:<\/strong> Enter:<\/li>\n<\/ul>\n<pre><code class=\"language-text\">a:1:{s:13:\"administrator\";s:1:\"1\";}\r\n<\/code><\/pre>\n<p>For example, if your table prefix is <code>wp_<\/code>, the meta_key should be:<\/p>\n<pre><code class=\"language-text\">wp_capabilities<\/code>\r\n\r\n\r\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13254\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/meta-details.webp\" alt=\"how-to-add-admin user-to-wordpress-database-from-phpmyadmin\" width=\"1918\" height=\"912\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/meta-details.webp 1918w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/meta-details-300x143.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/meta-details-1024x487.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/meta-details-768x365.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/meta-details-1536x730.webp 1536w\" sizes=\"(max-width: 1918px) 100vw, 1918px\" \/>\r\n\r\n\r\n<\/pre>\n<ul>\n<li>Click <strong>Go<\/strong> to save the record.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13255\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go2-1.webp\" alt=\"how-to-add-admin user-to-wordpress-database-from-phpmyadmin\" width=\"1918\" height=\"906\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go2-1.webp 1918w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go2-1-300x142.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go2-1-1024x484.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go2-1-768x363.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go2-1-1536x726.webp 1536w\" sizes=\"(max-width: 1918px) 100vw, 1918px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>Step 5: Set the Administrator User Level<\/h2>\n<p>Within the same <strong>databasename_usermeta<\/strong> table, click <strong>Insert<\/strong> again.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13256\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/usermeta-insert-1.webp\" alt=\"how-to-add-admin user-to-wordpress-database-from-phpmyadmin\" width=\"1913\" height=\"906\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/usermeta-insert-1.webp 1913w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/usermeta-insert-1-300x142.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/usermeta-insert-1-1024x485.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/usermeta-insert-1-768x364.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/usermeta-insert-1-1536x727.webp 1536w\" sizes=\"(max-width: 1913px) 100vw, 1913px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Enter the following values:<\/p>\n<ul>\n<li><strong>user_id:<\/strong> Enter the same user ID.<\/li>\n<li><strong>meta_key:<\/strong> Enter <code>databasename_user_level<\/code>.<\/li>\n<li><strong>meta_value:<\/strong> Enter:<\/li>\n<\/ul>\n<pre><code class=\"language-text\">10\r\n<\/code><\/pre>\n<p>For example, if your table prefix is <code>wp_<\/code>, the meta_key should be:<\/p>\n<pre><code class=\"language-text\">wp_user_level<\/code>\r\n\r\n\r\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13257\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/meta-details2.webp\" alt=\"how-to-add-admin user-to-wordpress-database-from-phpmyadmin\" width=\"1918\" height=\"911\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/meta-details2.webp 1918w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/meta-details2-300x142.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/meta-details2-1024x486.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/meta-details2-768x365.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/meta-details2-1536x730.webp 1536w\" sizes=\"(max-width: 1918px) 100vw, 1918px\" \/>\r\n\r\n<\/pre>\n<ul>\n<li>Click <strong>Go<\/strong> to save the changes.<\/li>\n<\/ul>\n<p>The newly created user now has administrator privileges.<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13258\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go3.webp\" alt=\"how-to-add-admin user-to-wordpress-database-from-phpmyadmin\" width=\"1917\" height=\"910\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go3.webp 1917w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go3-300x142.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go3-1024x486.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go3-768x365.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/go3-1536x729.webp 1536w\" sizes=\"(max-width: 1917px) 100vw, 1917px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>Step 6: Verify the New Administrator Account<\/h2>\n<p>Navigate to your WordPress login page and sign in using the username and password you created.<\/p>\n<p>Once logged in:<\/p>\n<ol>\n<li>Open the WordPress Dashboard.<\/li>\n<li>Click <strong>Users<\/strong> from the left navigation menu.<\/li>\n<li>Select <strong>All Users<\/strong>.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-13259\" src=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/result.webp\" alt=\"how-to-add-admin user-to-wordpress-database-from-phpmyadmin\" width=\"1918\" height=\"898\" srcset=\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/result.webp 1918w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/result-300x140.webp 300w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/result-1024x479.webp 1024w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/result-768x360.webp 768w, https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2026\/06\/result-1536x719.webp 1536w\" sizes=\"(max-width: 1918px) 100vw, 1918px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>Why to Add\u00a0 Admin User Through phpMyAdmin?<\/h2>\n<p>Creating a WordPress administrator account through phpMyAdmin can be useful in several situations:<\/p>\n<ul>\n<li>You have lost access to all administrator accounts.<\/li>\n<li>The administrator user was accidentally deleted.<\/li>\n<li>A plugin or theme conflict prevents access to the dashboard.<\/li>\n<li>Password reset emails are not being delivered.<\/li>\n<li>You need emergency access to troubleshoot website issues.<\/li>\n<li>You are recovering a compromised WordPress website.<\/li>\n<\/ul>\n<p>Since phpMyAdmin interacts directly with the database, it allows you to manage users even when the WordPress dashboard is unavailable.<\/p>\n<h2>Benefits of This Method<\/h2>\n<ul>\n<li>Quick Recovery<\/li>\n<li>No Dashboard Access Required<\/li>\n<li>Useful for Troubleshooting<\/li>\n<li>Secure Administrative Control<\/li>\n<li>Reliable Emergency Solution<\/li>\n<\/ul>\n<h2>Conclusion<\/h2>\n<p>Adding an administrator user through phpMyAdmin is a practical solution when you are locked out of WordPress or need to restore administrative access quickly. By creating a user in the users table and assigning administrator privileges through the usermeta table, you can regain full control of your website without requiring dashboard access. Following the steps outlined in this guide will help you safely create a new administrator account and continue managing your WordPress website with confidence.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to Add Admin User to\u00a0 WordPress Database from phpMyAdmin WordPress administrators occasionally face situations where they are unable to access the dashboard due to forgotten credentials, deleted administrator accounts, plugin conflicts, or security issues. When traditional password recovery methods fail, phpMyAdmin provides a reliable way to create a new administrator account directly from the [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":13260,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,2,10],"tags":[],"class_list":["post-13245","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-latest-updates","category-cpanel","category-wordpress"],"_links":{"self":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/13245","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/comments?post=13245"}],"version-history":[{"count":1,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/13245\/revisions"}],"predecessor-version":[{"id":13261,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/13245\/revisions\/13261"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media\/13260"}],"wp:attachment":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media?parent=13245"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/categories?post=13245"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/tags?post=13245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}