GRANT ALL ON database.* TO 'user'@'localhost';
/*Privilege Description
SELECT Ability to perform SELECT statements on the table.
INSERT Ability to perform INSERT statements on the table.
UPDATE Ability to perform UPDATE statements on the table.
DELETE Ability to perform DELETE statements on the table.
INDEX Ability to create an index on an existing table.
CREATE Ability to perform CREATE TABLE statements.
ALTER Ability to perform ALTER TABLE statements to change the table definition.
DROP Ability to perform DROP TABLE statements.
GRANT OPTION Allows you to grant the privileges that you possess to other users.
ALL Grants all permissions except GRANT OPTION.
*/