From d58045351725edca8fcb05a78c4b80865d7c3cf3 Mon Sep 17 00:00:00 2001 From: Andrew DeFaria Date: Thu, 6 Aug 2020 15:05:20 -0700 Subject: [PATCH] New MySQL syntax for creating user and granting privileges --- maps/bin/MAPSDB.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/maps/bin/MAPSDB.sql b/maps/bin/MAPSDB.sql index 1d25810..78cd5ad 100644 --- a/maps/bin/MAPSDB.sql +++ b/maps/bin/MAPSDB.sql @@ -88,5 +88,6 @@ create table log ( ); -- log -- Create users -grant all privileges - on MAPS.* to maps@"localhost" identified by "spam"; +-- New 8.0 syntax... +create user 'maps'@'localhost' identified by 'spam'; +grant all privileges on MAPS.* to 'maps'@'localhost'; -- 2.17.1