hariprasadraja
10/9/2019 - 11:22 AM

sql update grant privileges on all database

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.
*/