phpMyAdmin Help !

[adrian26v2 0]

hi

how can i make a new user in phpmyadmin and they can't see the other tables  

for example user1: have a ragnarok table then i create "user2" using my root account 

 

then after i create "user2 account" i want user2 account to don't see the user1: tables and also the root table's

thankyou!

[Rand 6]

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
   

 

 

 

Edited January 19, 2015 by Rand

[Legend 43]

This might solved your problem

1) Click the "users" button on your phpmyadmin.

 

2) Click edit privileges.

 

3) click check all and be sure everything in the "data", "structure" and "administration" must have a check mark.

 

 

4) scroll down to the bottom and you will find this "go" button. Click that.

 

5) And finally you must see this after doing all the steps above ^



Good luck!