Index: unix_installer/installer-package/sql-scripts/create-database.sql =================================================================== diff -u -rdcba8be00c08df0eb2ac0782c92c7d06f42dc881 -r1978c05357c5f9aa5a86696c7496854f50d27367 --- unix_installer/installer-package/sql-scripts/create-database.sql (.../create-database.sql) (revision dcba8be00c08df0eb2ac0782c92c7d06f42dc881) +++ unix_installer/installer-package/sql-scripts/create-database.sql (.../create-database.sql) (revision 1978c05357c5f9aa5a86696c7496854f50d27367) @@ -1,9 +1,7 @@ --- 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; +DROP DATABASE IF EXISTS lamstest; +CREATE DATABASE lamstest DEFAULT CHARACTER SET utf8; SET FOREIGN_KEY_CHECKS=1; -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@; +GRANT ALL PRIVILEGES ON *.* TO lamsusertest@localhost IDENTIFIED BY 'lamsdemo'; +REVOKE PROCESS,SUPER ON *.* from lamsusertest@localhost; +USE lamstest;