How do I change the privileges for MySQL user that is already created?
select * from mysql.user;
To show privileges:
show grants for 'user'@'host';
To change privileges, first revoke. Such as:
revoke all privileges on *.* from 'user'@'host';
Then grant the appropriate privileges as desired:
grant SELECT,INSERT,UPDATE,DELETE ON `db`.* TO 'user'@'host';