How to Add an Admin WordPress User with phpMyAdmin

Jan 14, 2019


Welcome to Utah SEO Expert, the leading provider of comprehensive SEO services for businesses and consumers. In this guide, we will walk you through the process of adding an admin WordPress user with phpMyAdmin.

Why Adding an Admin WordPress User is Important

Having an admin WordPress user account is crucial for managing your website effectively. It allows you to access all the backend features and settings of your WordPress site, giving you complete control over your content, plugins, and themes.

Step-by-Step Guide to Adding an Admin WordPress User with phpMyAdmin

Step 1: Accessing phpMyAdmin

The first step is to access phpMyAdmin, a powerful database management tool. To do this, log in to your hosting account and find the phpMyAdmin option. Click on it to proceed.

Step 2: Selecting the Database

Once inside phpMyAdmin, you will see a list of databases associated with your hosting account. Select the database that corresponds to your WordPress site from the dropdown menu.

Step 3: Navigating to the wp_users table

Within your selected database, locate the wp_users table. This table contains user information for your WordPress site. Click on it to open the table.

Step 4: Adding a New User

Now, you will see a list of existing users in the wp_users table. To add a new admin user, click on the "Insert" tab or button (depending on your phpMyAdmin version). This will allow you to insert a new row into the table.

Step 5: Filling in User Details

Fill in the required user details in the available fields. Some important fields to consider are:

  • user_login: Enter a unique username for the admin user.
  • user_pass: Enter a strong password for the admin user. Make sure to use a combination of uppercase and lowercase letters, numbers, and special characters.
  • user_email: Enter the admin user's email address.

Once you have filled in the required fields, click on the "Go" or "Insert" button to save the new user entry.

Step 6: Assigning Admin Privileges

By default, the newly added user will have a "subscriber" role. To assign admin privileges to the user, you need to update the user's role in the wp_usermeta table. Follow these steps:

  1. Navigate to the wp_usermeta table within your selected database.
  2. Search for the new user entry by looking for the user_login you created earlier.
  3. Locate the meta_key named wp_capabilities and click on it to edit the corresponding meta_value.
  4. In the meta_value field, replace the existing value with:a:1:{s:13:"administrator";s:1:"1";}
  5. Click on the "Go" or "Save" button to save the changes.

Step 7: Logging in with the New Admin User

Now that you have successfully added an admin WordPress user, you can log in using the credentials you provided during the user creation process. Visit your WordPress login page and enter the username and password of the new admin user.


Congratulations! You have learned how to add an admin WordPress user with phpMyAdmin. Having an admin account gives you the power to manage your website efficiently and make necessary changes to enhance its performance. Utah SEO Expert is here to assist you with all your SEO needs, ensuring that your website ranks high on search engine results pages (SERPs). Stay tuned for more informative guides and SEO tips!

Federico Lastra
I appreciate how you broke down the steps. It made the process feel much less intimidating.
Oct 16, 2023
Abhimanyu Sharma
I've gained a new skill today. Thank you for the guidance.
Aug 19, 2023
Phone2action Advocate
Thanks to your article, I now feel comfortable making changes through phpMyAdmin.
Jun 6, 2023
Nashid Haque
Been struggling with this for a while. Your article has come to my rescue. Thanks a bunch!
May 30, 2023
Diana Cruz
This was exactly what I needed. Thank you!
May 4, 2023
Kathy Murphy
I didn't realize how important it is to have an admin WordPress user until I read your article. It's so crucial!
Mar 30, 2023
Paul Sherman
I'm always afraid to mess with databases, but your guide made me feel confident enough to add an admin user.
Mar 25, 2023
Marilyn Moran-Townsend
I feel empowered to make changes to my database after reading your article. Thank you for the confidence boost.
Mar 24, 2023
Jason Lemaster
The detailed guidance in your article helped me navigate this task with ease. Thank you!
Jan 14, 2023
Luis Padilla
I can't wait to apply these steps. Thanks for the enlightenment.
Dec 26, 2022
I appreciate the step-by-step instructions. It makes the process so much easier.
Dec 9, 2022
Iram Weinstein
I'm bookmarking this for future reference. Your article is a lifesaver!
Sep 9, 2022
Alain Charron
I'm grateful for the practical tips. This will save me a lot of time.
Aug 29, 2022
Ivan Storck
This article was really helpful, thank you for the step-by-step guide!
Aug 6, 2022
Brian Campbell
Your article provided the exact solution I was looking for. I can't thank you enough!
Jul 13, 2022
Robo Warrior
Thanks for the detailed guide! Very useful information.
Jun 27, 2022
Palmer Stevens
I had no idea how to do this before. Thanks for making it simple to understand.
Jun 14, 2022
Patsy Bock
I always avoided dealing with databases, but your article gave me the confidence to try it. Thank you!
Apr 25, 2022
Masaki Nomura
Very helpful information. Thanks for taking the time to write this.
Mar 29, 2022
Michelle Cline
I'm amazed by how detailed and informative this guide is. Fantastic work!
Feb 12, 2022
Vlad Malykov
Your article saved my day! I really struggled with adding an admin user before finding this guide.
Feb 11, 2022
Brian Cunningham
This article deserves a share. It's a real time-saver.
Jan 31, 2022
Lucas Zago
This is a must-read for anyone dealing with WordPress admin users.
Dec 25, 2021
Thomas Lee
Now I can confidently add admin users using phpMyAdmin. Thank you!
Nov 29, 2021
Jason Tai
I've bookmarked this article for future reference. Thank you!
Nov 23, 2021
Joe Yaklic
I never thought it could be this easy. Thanks for shedding light on this.
Sep 22, 2021
Dominic Ciavatta
Great tutorial! Easy to follow steps.
Jul 31, 2021
Martin Weidner
I'm so glad I found this article. Your instructions solved my problem.
Jul 13, 2021
Alan Chu
Thank you for sharing your knowledge. It's greatly appreciated.
Apr 26, 2021
Muskan Sachdeva
I've been looking for a guide like this. Thank you!
Apr 11, 2021
Kudos for simplifying a potentially complex process. Your guide was fantastic!
Apr 1, 2021
Colin Gay
This is gold! Thank you for the invaluable information.
Mar 12, 2021
Your step-by-step approach is much appreciated. It truly helped me understand the process.
Mar 10, 2021
Jinger Zeng
I appreciate the detailed instructions. It's great to have this resource.
Feb 19, 2021
Xiangjun Wang
Adding an admin user through phpMyAdmin seemed complex, but your article simplified it for me. Thank you!
Feb 8, 2021
Ross Mills
Adding an admin user through phpMyAdmin made easy. Thanks for sharing!
Nov 11, 2020
Clint Terry
The importance of having an admin WordPress user cannot be overstated. Thanks for emphasizing it.
Jul 1, 2020
Nick Friend
I never knew phpMyAdmin could be used for this. Thanks for sharing!
May 29, 2020
Ruben Lorenzo
Clear and straightforward. Appreciate the insights.
May 18, 2020
Stephen Haffer
This article is a lifesaver! I was struggling with adding an admin user. 👍
May 15, 2020
Tim Bruner
I never knew how to do this before, but your article made it so clear. Thanks!
Mar 29, 2020
Dai Bui
Great content, thank you for sharing your expertise with us!
Mar 11, 2020
Katherine Stack
Nice and concise. Just what I was looking for.
Aug 9, 2019
Anastacia Wikstrom
Well-written and informative. Thank you for sharing your expertise.
Jun 24, 2019
Jill Kyte
I'm going to try this out. Hopefully, it works as explained.
May 15, 2019
Elyse Kelly
I've been struggling with this issue for a while. Thank you for providing a solution.
May 6, 2019
Maryam Zahory
The clarity and simplicity of your explanations made this task much less daunting. Thank you!
Apr 21, 2019
Jeff Gulla
Your article is just what I needed to understand this process. Thank you for the clear instructions.
Apr 19, 2019
Sina R
Adding an admin user through phpMyAdmin seems easier than I thought. Thanks for the tips!
Mar 20, 2019
Lucena Wagner
I've been looking for a clear guide on this topic. Your article is exactly what I needed. Thank you!
Mar 6, 2019
Bob Morris
It's important to have clear instructions and this article delivers exactly that. Well done!
Feb 3, 2019