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?
Webmasters Stack Exchange is a question and answer site for pro webmasters. It only takes a minute to sign up.
Sign up to join this communityTry this:
You should see the new user in the User overview. Global privileges should say "Usage".
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.
When you login to phpMyAdmin as the root user you are able to view ALL the databases and perform operations on any of them.
If you want to limit access to only a specific user:
user1
with their password1
user1
and password1
they will only have access to the specific database.Then follow the step's from intlect's answer to create a users and assign them to a specific database:
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.