How to grant privileges to a user in phpMyAdmin?


by larissa , in category: Third Party Scripts , 10 months ago

How to grant privileges to a user in phpMyAdmin?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by darrion.kuhn , 10 months ago


To grant privileges to a user in phpMyAdmin, follow these steps:

  1. Open phpMyAdmin and log in to your database.
  2. In the main page, click on the "Privileges" tab.
  3. Click on the "Add a new User" link or choose an existing user from the list to grant privileges to.
  4. On the "Edit Privileges" page, you can set the user's login information (username and password).
  5. Under the "Database for User" section, select the database you want to grant privileges for or select the "All databases" option.
  6. Scroll down to the "Global privileges" section and select the privileges you want to grant to the user. Common privileges include SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, and so on.
  7. You can also set specific privileges for each table in the "Database-specific privileges" section. Click on the "Check All" link to grant all privileges for a specific table.
  8. Once you have set the desired privileges, click on the "Go" button at the bottom of the page to save the changes.

The user will now have the specified privileges for the selected database(s) and tables in phpMyAdmin.