X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=init.sql;fp=init.sql;h=fbe16ce8e90ff583863e2ae0d6ef2633d8027386;hb=ab5d8a35c1c111f64137f76939c68365cf4d22fb;hp=29b4a25d7fee1c3bafa8330c1c3ff14a9276e6ad;hpb=c00b46344cce7b05d6e0db74359de1971d2d09ec;p=nbtscanner diff --git a/init.sql b/init.sql index 29b4a25..fbe16ce 100644 --- a/init.sql +++ b/init.sql @@ -1,6 +1,6 @@ USE mysql; -INSERT INTO mysql.user (Host, User, Password) VALUES('%', 'nbtscanner', PASSWORD('tg01')); -INSERT INTO mysql.user (Host, User, Password) VALUES('localhost', 'nbtscanner', PASSWORD('tg01')); +INSERT INTO mysql.user (Host, User, Password) VALUES('%', 'nbtscanner', PASSWORD('qugx8M!S')); +INSERT INTO mysql.user (Host, User, Password) VALUES('localhost', 'nbtscanner', PASSWORD('qugx8M!S')); FLUSH PRIVILEGES; CREATE DATABASE nbtscanner; @@ -14,4 +14,5 @@ CREATE TABLE nbtscanner ( ip ) ); -GRANT INSERT, UPDATE, DELETE ON nbtscanner.nbtscanner TO nbtscanner@"%" IDENTIFIED BY 'tg01'; +GRANT SELECT, INSERT, UPDATE, DELETE ON nbtscanner.nbtscanner TO nbtscanner@localhost IDENTIFIED BY 'qugx8M!S'; +GRANT SELECT, INSERT, UPDATE, DELETE ON nbtscanner.nbtscanner TO nbtscanner@"%" IDENTIFIED BY 'qugx8M!S';