Create a new user admin via phpmyadmin

Here's a step-by-step guide to create a new user admin via phpMyAdmin:

Prerequisites:

• You have phpMyAdmin installed and accessible on your server.
• You have a MySQL database set up and running.
• You have the necessary permissions to create a new user.

Step 1: Log in to phpMyAdmin

Open a web browser and navigate to the phpMyAdmin URL (e.g., http://example.com/phpmyadmin). Log in with your existing username and password.

Step 2: Select the database

In the phpMyAdmin dashboard, select the database you want to create the new user for from the dropdown menu at the top.

Step 3: Click on the "Users" tab

In the left-hand menu, click on the "Users" tab.

Step 4: Click on the "Add user" button

Click on the "Add user" button at the top of the page.

Step 5: Fill in the user details

Fill in the following details:

• User name: Enter a unique username for the new user (e.g., newadmin).
• Host: Select the host you want the user to connect from (e.g., % for any host).
• Password: Enter a strong password for the new user.
• Password (again): Re-enter the password to confirm.
• Database: Select the database you want the user to have access to.
• Privileges: Select the privileges you want to grant to the new user (e.g., SELECT, INSERT, UPDATE, DELETE, etc.).

Step 6: Set the user privileges

In the "Privileges" section, you can set specific privileges for the new user. For example, you can grant the user SELECT privileges on a specific table or database.

Step 7: Click on the "Go" button

Click on the "Go" button to create the new user.

Step 8: Verify the user creation

After clicking on the "Go" button, phpMyAdmin will create the new user. You can verify the user creation by checking the "Users" tab again. The new user should be listed with the privileges you specified.

That's it! You have successfully created a new user admin via phpMyAdmin.