Take the 2-minute tour ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.

I am using phpmyadmin to control mysql on my server, now i want to create some users to access this admin tool, what i want is to make each user can create databases but can't see others databases.

Is that possible and how?

share|improve this question

3 Answers 3

up vote 5 down vote accepted

Try this:

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

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

  1. Click on the edit icon next the the User's account
  2. Under "Database-specific privileges" where it says "Add privileges on the following database" chose the database(s) you wish to assign to the user
  3. Assign the User whatever privileges you wish them to have for that database
  4. Press the "Go" button
share|improve this answer
  1. Login to phpMyADmin
  2. Go to Privileges
  3. Click Add a new User
  4. Type the access info you want in the Login Information area (username, host, password)
  5. Click on the radio button for Create database with same name and grant all privileges
  6. Click Go.
share|improve this answer
  1. Login to phpMyADmin
  2. Go to Privileges
  3. Click Add a new User
  4. Type the access info you want in the Login Information area (username, host, password)
  5. Click on the radio button for Create database with same name and grant all privileges
  6. 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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.