MySql GRANT error: 'Select' is not valid at this position

Question

I'm trying to assign rights to newly created user sing MySQL Workbench but it gives me error as below (User creation was successful)

Version : 8.0.17 OS: MacOS Mojave

PS: GRANT all ONmy_schema.* TO 'admin'@'localhost'; was successful

Answer 1

you missed a comma between update and delete

GRANT SELECT,INSERT,UPDATE,DELETE ON my_schema.* TO 'admin'@'localhost';

works also