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:
Select the WordPress site’s database from the list of databases on the and then, click on 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.