ACP with Mariadb

Steps to setup the ACP databse for use with Mariadb

Install MariaDB server

• download Mariadb 10.6.2 (Current tested version).
• Launch the installer - accept defaults including Heidisql
• Set a new root password when prompted
• Check allow remote access for root for now.
• Install as service - service name Mariadb
• Enable networking - port 3306
• Finish installing with defaults

Setup HeidiSQL

Optional - Allows you to use a GUI, but all can be done with the command prompt. *Launch HeidiSQL

• Click new session at bottom left
  • Network type Mariadb or Mysql (default)
  • Library Libmaria.dll (default)
  • Hostname / IP 127.0.0.1 (default)
  • leave unchecked prompt for credentials and Windows authentication (default)
  • User: root
  • Password - enter the password for root
  • port 3306
  • leave the rest default and click [Open]

• Install the MariaDB ODBC driver
• Add the Suan assets models with Mariadb compatible MYSQL calls to the UI folder.