New MySQL syntax for creating user and granting privileges

[clearscm.git] / maps / bin / MAPSDB.sql

diff --git a/maps/bin/MAPSDB.sql b/maps/bin/MAPSDB.sql
index dfe0a4f..78cd5ad 100644 (file)
--- a/maps/bin/MAPSDB.sql
+++ b/maps/bin/MAPSDB.sql
@@ -88,9 +88,6 @@ create table log (
 ); -- 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';