I recently created a mysql db with three different users using the MySql Account Maintenance through cpanel. phpMyAdmin has no options for users privileges. I have been able to use MySql Control Center to create tables and manipulate data, but am unable to modify the privileges via User Administration.
When I create a user it grants ALL Privileges by default. I have tried to change to privileges unsuccessfully.
Two of the accounts on the db I am trying to create are: admin – ALL privileges; and users – privileges include: select, update, insert and delete.
Any ideas?
