updated the sql to permit the creation of the database from the console

[gosa.git] / contrib / mysql / golog / golog.sql

diff --git a/contrib/mysql/golog/golog.sql b/contrib/mysql/golog/golog.sql
index 6e0252af43ad3174733b787b93a40d3ffbfa4576..0461fdc48e191f0c86ac93e938482def37268d3b 100644 (file)
--- a/contrib/mysql/golog/golog.sql
+++ b/contrib/mysql/golog/golog.sql
@@ -1,5 +1,6 @@
 
-create database golog with owner gomon;
+create database golog;
+use golog;
 
 create table golog (
        time_stamp DATETIME,
@@ -10,4 +11,4 @@ create table golog (
        matched_ts DATETIME
        );
 
-GRANT ALL PRIVILEGES ON golog TO gomon WITH GRANT OPTION;
+GRANT INSERT,SELECT,DELETE ON golog.golog TO gomon@localhost IDENTIFIED BY 'somemysqlpass';