: How to create separate users in phpmyadmin, each one can't see others databases? I am using phpmyadmin to control mysql on my server, now i want to create some users to access this admin tool,

@Yeniel560

On the phpMyAdmin default page

select the database you want this user to have access to

click the privileges tab

Click on the Add a new User

Assign the User a Login Information

User name:

Host name:

Password:

Re-type:

Authentication Plugin

Where it says "Database for User Account Grant all privileges on database "database name".

tick all checkboxes in global privileges Press the "Go" button

You should see the new user in the User overview. Global privileges should say "ALL PRIVILEGES".

This should resolve your issue.

Vote Up Vote Down

@Correia994

Login to phpMyADmin
Go to Privileges
Click Add a new User
Type the access info you want in the Login Information area (username, host, password)
Click on the radio button for Create database with same name and grant all privileges
Click Go.


That's it.

Note. I prefer to have a combination where the username is the same as the database name - some may argue against it. I'm using phpMyAdmin version 3.3.2.

Vote Up Vote Down

@Sarah324

Try this:


On the phpMyAdmin default page (localhost) click on the "Privileges" link
Click on the "Add a new User link"
Assign the User a login and password
Where it says "Database for User" select "None"
Leave all checkboxes in global privileges unchecked
Press the "Go" button


You should see the new user in the User overview. Global privileges should say "Usage".


Click on the edit icon next the the User's account
Under "Database-specific privileges" where it says "Add privileges on the following database" chose the database(s) you wish to assign to the user
Assign the User whatever privileges you wish them to have for that database
Press the "Go" button

Vote Up Vote Down