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.
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.
Usamos cookies con el fin de personalizar para usted nuestro sitio Web y analizar el uso de éste. Usted acepta esto haciendo clic en “Acepto” o al continuar usando el sitio Web. Hay más información sobre cookies en nuestra política de privacidad.