Add 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.
• 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 (username and password).

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

UPDATE admin_user SET username = 'new_username', email = '[email protected]', password = 'new_password' WHERE username = 'old_username';

Replace new_username, [email protected], new_password, and old_username with the actual values for your new admin user.