Index: unix_installer/installer-package/sql-scripts/create-database.sql =================================================================== diff -u -rc6a8998567722aec174bb639b1fb4d81dece93d8 -rdcba8be00c08df0eb2ac0782c92c7d06f42dc881 --- unix_installer/installer-package/sql-scripts/create-database.sql (.../create-database.sql) (revision c6a8998567722aec174bb639b1fb4d81dece93d8) +++ unix_installer/installer-package/sql-scripts/create-database.sql (.../create-database.sql) (revision dcba8be00c08df0eb2ac0782c92c7d06f42dc881) @@ -1,7 +1,9 @@ +-- This is used for a local database only (so @SQL_HOST@) always ends up as localhost. For separate MySQL servers, the user and the db must be created manually. + SET FOREIGN_KEY_CHECKS=0; DROP DATABASE IF EXISTS @DB_NAME@; CREATE DATABASE @DB_NAME@ DEFAULT CHARACTER SET utf8; SET FOREIGN_KEY_CHECKS=1; -GRANT ALL PRIVILEGES ON *.* TO @DB_USER@@@SQL_GRANT@ IDENTIFIED BY '@DB_PASS@'; -REVOKE PROCESS,SUPER ON *.* from @DB_USER@@@SQL_GRANT@; +GRANT ALL PRIVILEGES ON *.* TO @DB_USER@@@SQL_HOST@ IDENTIFIED BY '@DB_PASS@'; +REVOKE PROCESS,SUPER ON *.* from @DB_USER@@@SQL_HOST@; USE @DB_NAME@;