Re: Database Permissions, deny for one User one Database

[Jonathon Coombes]

Hi Daniel,
It sounds like you are trying to set your privileges by updating the mysql.user and mysql.db tables. This is something that should have stopped many years ago as there is the GRANT/REVOKE statements that will make it much easier. So instead of having to work out a complex table update for a user to be able to read and update a table, but not delete from it, you can simply do:

mysql> GRANT SELECT, INSERT, UPDATE ON mydb.* TO 'user'@'localhost';

This will update the appropriate tables and flush the privileges to make them immediate. This is a much simpler solution, and is consistent across the majority of database servers being used.