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?
How to create separate users in phpmyadmin, each one can't see others databases?
php;mysql
Try this:On the phpMyAdmin default page (localhost) click on the Privileges linkClick on the Add a new User linkAssign the User a login and passwordWhere it says Database for User select NoneLeave all checkboxes in global privileges uncheckedPress the Go buttonYou should see the new user in the User overview. Global privileges should say Usage.Click on the edit icon next the the User's accountUnder Database-specific privileges where it says Add privileges on the following database chose the database(s) you wish to assign to the userAssign the User whatever privileges you wish them to have for that databasePress the Go button