Key Takeaways<\/strong><\/p>\n\n\n\n \ud83d\udcda Table of contents<\/strong>:<\/p>\n\n\n\n \ud83d\udca1 Note<\/strong>: if you’re looking for a hosting provider that offers access to phpMyAdmin, we recommend Bluehost<\/a> or A2 Hosting<\/a>. These two have been solid choices for all types of websites – as we’ve covered in numerous comparisons on the site.<\/p>\n\n\n<\/div><\/div>\n\n\n\n Before you add new user, you’ll need to access phpMyAdmin – it\u2019s not a plugin, but rather a free software tool written in PHP – and edit your database<\/a>. You can usually do so via a link in your WordPress hosting account<\/a> dashboard.<\/p>\n\n\n\n The exact name varies depending on the host, but look for options such as:<\/p>\n\n\n\n Here’s what it looks like in cPanel<\/a>:<\/p>\n\n\n Now, select your WordPress site’s database<\/a> from the list of databases on the left. Then, click on the Note – some hosts change the prefix of the In the On the next screen, you’ll see a form:<\/p>\n\n\n\n Fill in the following details:<\/p>\n\n\n\n Don\u2019t worry about the other fields; leave them empty for now. Once you’ve filled out the fields, scroll to the bottom and click Go<\/em><\/strong>:<\/p>\n\n\n After clicking Go<\/em><\/strong>, you should see a success screen confirming the activation of the above sequence. If you go back to the To finish things out, go to the Then, fill in the following values (again, leave the other fields empty):<\/p>\n\n\n\n Click on Go<\/em><\/strong> to complete the user creation process. You can now log in to your WordPress site using the credentials from Step 3.<\/p>\n\n\n As you can see, not all is lost if you’re locked out of your admin dashboard. It\u2019s still possible to create a new WordPress admin login using phpMyAdmin to restore access. Such a situation can happen to ecommerce, small business, WordPress blogs, and all types of WordPress users alike.<\/p>\n<\/div>\n\n\n\n\n
\n
\n
How to create a new WordPress admin user with phpMyAdmin \ud83d\udcdd<\/h2>\n\n\n
Step 1: Access your MySQL database \ud83d\uddc4\ufe0f<\/h3>\n\n\n\n
\n
![\"How](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2020\/07\/access-phpmyadmin.jpg\")
<\/figure><\/div>\n\nStep 2: Go to the wp_users<\/em> table \ud83d\uddc3\ufe0f<\/h3>\n\n\n\n
wp_users<\/code> table.<\/p>\n\n\n\nwp_users<\/code> table<\/a> for security. For example, you might see it as wpud_users<\/code>. Just open the table that says [something]_users<\/code>.<\/p>\n\n\n![\"Accessing](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2020\/07\/wp-users-table.png\")
<\/figure><\/div>\n\nStep 3: Insert a new WordPress admin user in the users table \ud83e\uddd9\u200d\u2642\ufe0f<\/h3>\n\n\n\n
wp_users<\/code> table, click on the Insert<\/em><\/strong> tab.<\/p>\n\n\n\n![\"Add](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2020\/07\/insert-new-user.png\")
<\/figure>\n\n\n\n\n
user_login<\/code>: Insert the username you want to use for your new admin user.<\/li>\n\n\n\nuser_pass<\/code>: Add a password for the account and select MD5<\/em><\/strong> in the Function<\/em><\/strong> drop-down.<\/li>\n\n\n\nuser_email<\/code>: Add the email address you want to use.<\/li>\n\n\n\nuser_registered<\/code>: Select the date and time for when this user should be registered. <\/li>\n\n\n\nuser_status<\/code>: Set this value to zero.<\/li>\n<\/ul>\n\n\n\n![\"Add](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2020\/07\/insert-new-user.jpg\")
<\/figure><\/div>\n\n\nwp_users<\/code> table, you should see your new user. Pay attention to the value in the ID<\/code> column, as you’ll need this in the next step:<\/p>\n\n\n![\"New](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2020\/07\/new-user.jpg\")
<\/figure><\/div>\n\nStep 4: Insert user meta values \u2705<\/h3>\n\n\n\n
wp_usermeta<\/code> table and click on Insert<\/em><\/strong>. Again, the name might be slightly different – just look for the table that says [something]_usermeta<\/code>.<\/p>\n\n\n\n\n
user_id<\/code>: Fill in the ID<\/code> of the user you created in the previous step. <\/li>\n\n\n\nmeta_key<\/code>:<\/strong> Enter wp_capabilities<\/code><\/li>\n\n\n\nmeta_value<\/code>: Fill in the field with a:1:{s:13:\"administrator\";s:1:\"1\";}<\/code><\/li>\n<\/ul>\n\n\n![\"Add](\"https:\/\/mllj2j8xvfl0.i.optimole.com\/cb:c5QE.37290\/w:auto\/h:auto\/q:mauto\/f:best\/https:\/\/themeisle.com\/blog\/wp-content\/uploads\/2020\/07\/add-capability.jpg\")
<\/figure><\/div>\n\n\nConclusion \ud83c\udfc1<\/h2>\n\n\n\n