MySQL Install instructions

Initial version

Version 1.0

Prerequisites

  • Windows 10 or other Windows OS
  • Minimum 2GB of free disk space
  • Build directory = {drive letter}:/enactorBuild/
  • Any other 3rd party applications to be installed prior to Enactor
  • Download the mysql installer for version 5.7 from this page: https://dev.mysql.com/downloads/windows/installer/5.7.html

Install steps using installer GUI

  1. Create build directory
    1. D:\enactorBuild\
  2. Copy install msi into build directory
    1. mysql-installer-community-5.7 + Not 5.8
  3. Run the msi with administrator permissions
  4. Select “Server only” setup type. Press Next and then Execute

  1. After installation is complete press Next and on Product configuration press Next again
  2. Choose Config Type: Sever Machine and leave default port 3306 and press Next

  1. Enter Root account password as provided
  2. Add user: enactorpos with password as provided and set Host to localhost

  1. On Windows Service screen press Next and then Execute
  2. Once configuration has been applied press the Finish button.

MySQL configuration

  1. Edit “my.ini” config file which is located in C:\ProgramData\MySQL\MySQL Server 5.6, scroll to the botton and add following entries:
  2. innodb_file_format=barracuda
  3. innodb_file_per_table=true
  4. innodb_large_prefix=ON
  5. innodb_buffer_pool_size = 1G
  6. innodb_log_buffer_size = 256M
  7. innodb_log_file_size = 256M
  8. innodb_write_io_threads = 16
  9. innodb_flush_log_at_trx_commit = 0
  10. max_allowed_packet=32M

and save the file.

    1. Optional you can apply recommended performance tweaks as per your DBA instructions
  1. Restart MySQL56 windows service

  1. Login as root to mysql command line client (which you can find in the windows Start menu)
    1. On test tills you can install and use workbench for easier access
  2. Create schema ‘enactorpos’ by executing following command:
  3. CREATE DATABASE enactorpos;
  4. Type exit to leave MySQL Command Line Client

Database Values

Description Value System Variable Hard Coded
Root password TBC
POS Database Name enactorpos Yes
POS Database User Name enactorpos Yes
POS Database User Password TBC No