GRANT SELECT ON world.* TO 'jim'@'localhost' IDENTIFIED BY 'Abc123';
GRANT SELECT, INSERT, DELETE, UPDATE ON world.* TO 'jim'@'localhost' IDENTIFIED BY 'Abc123';
GRANT SELECT (ID, Name, CountryCode), UPDATE (Name, CountryCode) ON world.City TO 'jim'@'localhost' IDENTIFIED BY 'Abc123';