GRANT ALL
ON *.*
TO nicole
WITH GRANT OPTION
GRANT SELECT, INSERT, UPDATE
ON dataExamples.*
TO nicole@localhost
GRANT SELECT, INSERT, UPDATE
ON dataExamples.spacefirsts
TO nicole@localhost
Granting Global Access to User “nicole”
Granting Database Access to User “nicole” just on the local machine
Granting Table Access to User “nicole” just on the local machine