All of the SQL and ORM Examples in this book use the MySQL test database
Make sure that you have MySQL installed.
This needs to be done as the root MySQL user
wget https://github.com/datacharmer/test_db/archive/master.zip yum install unzip cd test_db-master/ mysql -u root -p < employees.sql
We are doing this separately so that we do not have to change your MySQL config to InnoDB, if it was configured as MyISAM.
You can sheck if your tables are alraedy InnoDB by running from MySQL:
USE employees; SHOW TABLE STATUS;
ALTER TABLE dept_emp ENGINE=InnoDB; ALTER TABLE dept_manager ENGINE=InnoDB; ALTER TABLE titles ENGINE=InnoDB; ALTER TABLE salaries ENGINE=InnoDB; ALTER TABLE employees ENGINE=InnoDB; ALTER TABLE departments ENGINE=InnoDB;
We'll use this user to connect form our application. We set localhost and a wildcard host, '%', to cover scenarios where Lucee is installed on the same server as the test database, or a remote server.
create database employees; create user employees@'%' identified by '123456'; grant all on employees.* to employees@'%' identified by '123456'; grant all on employees.* to employees@'localhost' identified by '123456'; flush privileges;