Create new user with all priviledges phpmyadmin

To create a new user with all privileges in PHPMyAdmin, you can follow these steps:

  1. Log in to your PHPMyAdmin dashboard.
  2. Click on the "Users" tab.
  3. Click on the "Add user" button.
  4. Fill in the required information for the new user:
    • User name: Enter the desired username for the new user.
    • Password: Enter a strong password for the new user.
    • Host: Select "localhost" or the hostname of your MySQL server.
    • Database: Select the database you want the new user to have access to.
  5. Click on the "Go" button to create the new user.
  6. Once the user is created, click on the "Privileges" tab.
  7. Click on the "Check all" box to select all privileges for the new user.
  8. Click on the "Go" button to apply the changes.

Here is an example of what the "Privileges" tab might look like:

Privilege Action
Select
Insert
Update
Delete
Create
Drop
Grant
References
Index
Alter
Create temporary tables
Lock tables
Execute
Show view
Create view
Show full tables
Super
Create routine
Alter routine
Execute routine

By selecting all privileges, the new user will have full access to the database and can perform any action, including creating, modifying, and deleting tables, as well as executing queries.

Note: Be careful when granting all privileges to a user, as it can pose a security risk if the user is compromised. It's generally recommended to only grant the necessary privileges to a user based on their specific role or responsibilities.