X-Git-Url: https://defaria.com/gitweb/?a=blobdiff_plain;f=maps%2Fbin%2FMAPSDB.sql;h=78cd5ad9162c5c07cd8eaa7da077ef1745a18285;hb=7ad5fd1a2d54b940018de904485ce560562af176;hp=dfe0a4ff8d7fd037264aac4c4236d23b22799a45;hpb=1f0a76df468c6ae7ee878730cc68fc133c70c0a5;p=clearscm.git diff --git a/maps/bin/MAPSDB.sql b/maps/bin/MAPSDB.sql index dfe0a4f..78cd5ad 100644 --- 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';