); -- log
-- Create users
-grant all privileges
- on MAPS.* to mapsadmin@"localhost" identified by "mapsadmin";
-grant select
- on MAPS.* to mapsreader@"localhost" identified by "reader";
-grant insert, select, update, delete
- on MAPS.* to mapswriter@"localhost" identified by "writer";
+-- New 8.0 syntax...
+create user 'maps'@'localhost' identified by 'spam';
+grant all privileges on MAPS.* to 'maps'@'localhost';