1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Assigning different rights to MySQL database users
Actions to becarried out
Log into your control panel
Go to Tools -> Databases
Add a new user and tick the boxes for therequired permissions
Withread permission a user may only view the structure and content of a tableand therefore issue SELECT queries.
With write permission they mayalter the structure and content of the corresponding database.
Withadministrator rights they may delete it.
If a user has no rights over adatabase, they will not see it displayed in phpMyAdmin.
Link to this FAQ: