You can create a user in WordPress in two ways: through the WordPress admin dashboard or by directly creating a user on the database. If you have lost access to your administrator login, then this article will demonstrate how to create an admin user on a MySQL database using phpMyAdmin for WordPress.
To create a user on MySQL using phyMyAdmin, follow these steps:
If you are using the Paper Lantern theme, in the DATABASES section of the cPanel home page, click phpMyAdmin:
Select the WordPress site’s database from the list of databases, and then click the wp_users table:
On the wp_users table or prefix_users, click on the Insert tab, and then fill in the form:
Fill in the user form with the following details, and then to save the details click the Go button:
Click on the browse tab to view the newly created user:
Click on the wp_usermeta or [prefix]_usermeta table, and then click the Insert tab:
Fill in the following values (leave the other fields empty) and then click Go:
Subscribe to receive weekly cutting edge tips, strategies, and news you need to grow your web business.
No charge. Unsubscribe anytime.
Did you find this article helpful? Then you'll love our support. Experience the A2 Hosting difference today and get a pre-secured, pre-optimized website. Check out our web hosting plans today.