User Administration & Mysql

[Metdol]

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?

[TCH-Dick]

Use MySql Account Maintenance to delete the user from the DB, then add it back with the desired privileges.