Add a new admin magento phpmyadmin

Here are the steps to add a new admin user in Magento using PHPMyAdmin:

Prerequisites:

• You have access to your Magento database using PHPMyAdmin.
• You have the database username and password.

Step 1: Log in to PHPMyAdmin

Open PHPMyAdmin and log in using your database username and password.

Step 2: Select the Magento database

In the PHPMyAdmin dashboard, select the Magento database from the list of databases.

Step 3: Navigate to the admin_user table

In the Magento database, navigate to the admin_user table. This table contains all the admin users in your Magento store.

Step 4: Insert a new row

Click on the "Insert" tab at the top of the page to insert a new row into the admin_user table.

Step 5: Fill in the required fields

Fill in the required fields as follows:

• username: Enter a unique username for the new admin user.
• email: Enter the email address for the new admin user.
• password: Enter a password for the new admin user. You can use a password generator tool to generate a strong password.
• firstname and lastname: Enter the first name and last name for the new admin user.
• role_id: Set this to 2 for a standard admin user.
• is_active: Set this to 1 to enable the new admin user.

Step 6: Save the changes

Click on the "Go" button to save the changes.

Step 7: Log in to Magento as the new admin user

Open your Magento store's admin dashboard and log in using the new admin user's credentials.

Note: Make sure to update the admin_user table in the Magento database to reflect the new admin user's role and permissions. You can do this by running the following SQL query:

UPDATE admin_user SET role_id = 2 WHERE username = '<new_username>';

Replace <new_username> with the actual username you created in Step 5.

That's it! You have successfully added a new admin user in Magento using PHPMyAdmin.