Instructions for creating an account in phpMyAdmin

It seemed like this job was simple, but when I encountered it, it took me quite a bit of time to handle it.

In the case of receiving customer projects, we limit asking for Admin login accounts and passwords. I also do not ask customers to create new user accounts, but add them themselves in phpMyAdmin. After completing the project, I will delete this account and hand it over to the customer.

Step 1: Create a new user in the "wp_users" table

• Access to phpMyAdmin → go to the table wp_users
• To create a new account, click Insert in the top bar.
• user_login: Enter your login name.
• user_pass: select MD5 → then enter the password for this new account.
• Scroll down and press the button Go to create.
• After the step above, you will see a new user just created ID. You need to copy the code ID This.

Step 2: Assign user rights in the "wp_usermeta" table

• Go to the board wp_usermeta
• Press Insert in the top bar of the table wp_usermeta
• user_id: fill in the code ID that you created in step 1. For example my ID is 5.
• meta_key: type "wp_capabilities".
• meta_value: type "a:1:{s:13:"administrator";b:1;}".
• Scroll down and press the button Go.

So you have completed creating a new account in phpMyAdmin. Good luck.