How To Create Separate Users For Separate Database In PhpMyAdmin, So That Each One Can’t See Others Databases

phpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL or MariaDB with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.

Steps:

  1. Login to phpMyAdmin using root credentials.
  2. On the phpMyAdmin default page click on user tab
  3. Click on the “Add User”
  4. Fill only the following details
    1. User name
    2. Password:
    3. Leave all other options and click on Go
  • You should see the new user in the User overview. Global privileges should say “Usage”
  • Click on the “Edit Privileges” of the user that you are created.
  • Go to Database-specific privileges Section and Select the database in front of Add privileges on the following database
  • You will automatically redirect to Database-specific privileges (Check All /Uncheck All), Select privileges and click on Go.
  • That's It
Comments are closed