diff options
| author | Carlos Konstanski <ckonstanski@pippiandcarlos.com> | 2018-02-23 15:13:20 -0700 |
|---|---|---|
| committer | Carlos Konstanski <ckonstanski@pippiandcarlos.com> | 2018-02-23 15:13:20 -0700 |
| commit | 8bc3490a4c72faf7d4385e93eefa887c9b1dabc2 (patch) | |
| tree | c07caf4a150bf73acda822d0a8175b694f288283 /salt/openbook/database/files/create_openbook_schemas.sql.orig | |
| parent | ffa4d60e8490e54bd9455adc6497d4a84c1c1407 (diff) | |
Add db.user and db.password to Openbook JSON
Issue: IS-64
Diffstat (limited to 'salt/openbook/database/files/create_openbook_schemas.sql.orig')
| -rw-r--r-- | salt/openbook/database/files/create_openbook_schemas.sql.orig | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/salt/openbook/database/files/create_openbook_schemas.sql.orig b/salt/openbook/database/files/create_openbook_schemas.sql.orig index 127e740..60f40b9 100644 --- a/salt/openbook/database/files/create_openbook_schemas.sql.orig +++ b/salt/openbook/database/files/create_openbook_schemas.sql.orig @@ -14,8 +14,8 @@ CREATE DATABASE /*!32312 IF NOT EXISTS*/ `openbook` /*!40100 DEFAULT CHARACTER SET utf8 */; -GRANT ALL PRIVILEGES ON openbook.* TO openbook@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; -GRANT ALL PRIVILEGES ON openbook.* TO openbook@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; +GRANT ALL PRIVILEGES ON openbook.* TO {% raw %}{{ openbook_database_user }}{% endraw %}@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; +GRANT ALL PRIVILEGES ON openbook.* TO {% raw %}{{ openbook_database_user }}{% endraw %}@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; FLUSH PRIVILEGES; USE `openbook`; @@ -2353,8 +2353,8 @@ DELIMITER ; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `openbook_jobs` /*!40100 DEFAULT CHARACTER SET utf8 */; -GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; -GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; +GRANT ALL PRIVILEGES ON openbook_jobs.* TO {% raw %}{{ openbook_database_user }}{% endraw %}@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; +GRANT ALL PRIVILEGES ON openbook_jobs.* TO {% raw %}{{ openbook_database_user }}{% endraw %}@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; FLUSH PRIVILEGES; USE `openbook_jobs`; @@ -2600,8 +2600,8 @@ UNLOCK TABLES; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `openbook_workflow` /*!40100 DEFAULT CHARACTER SET utf8 */; -GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; -GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; +GRANT ALL PRIVILEGES ON openbook_workflow.* TO {% raw %}{{ openbook_database_user }}{% endraw %}@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; +GRANT ALL PRIVILEGES ON openbook_workflow.* TO {% raw %}{{ openbook_database_user }}{% endraw %}@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}'; FLUSH PRIVILEGES; USE `openbook_workflow`; |