View source for ACP with Mariadb

'''''<font color=blue>Page is under construction</font>'''''

Steps to setup the ACP database for use with Mariadb

===Install MariaDB server===
* [https://mariadb.org/download/?t=mariadb&p=mariadb&r=11.6.2&os=windows&cpu=x86_64&pkg=msi&mirror=xtom_fre 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
(You need to start a session too create a database)
*Click new session at bottom left - then you can leave all as default for now 
**<code>Network type</code> '''<code>Mariadb or Mysql </code>'''(default)
**<code>Library</code> '''<code>Libmaria.dll </code>'''(default)
**<code>Hostname</code> / IP '''<code>127.0.0.1</code>''' (default)
**leave unchecked prompt for credentials and Windows authentication (default)
**<code>User: </code>'''<code>root</code>'''
**<code>Password</code> - enter the password for root
**<code>port</code> '''<code>3306</code>'''
**leave the rest default and click [Open] 
'''Expected: New session starts - there are no user databases yet'''
===Create database===
*In HeidiSQL right click on the session name ('''Unnamed''' unless you named it) > Select '''<code>Create New ></code>''' > '''<code>Database</code>''' > '''<code>suan_subscriptions</code>''' > Press '''<code>[OK]</code>'''

===Install the MariaDB ODBC connector===
*Download the [https://mariadb.com/download-confirmation/?group-name=Data%20Access&release-notes-uri=https%3A%2F%2Fmariadb.com%2Fkb%2Fen%2Fmariadb-connector-c-3-4-3-release-notes%2F&documentation-uri=https%3A%2F%2Fmariadb.com%2Fkb%2Fen%2Fabout-mariadb-connector-c%2F&download-uri=https%3A%2F%2Fdlm.mariadb.com%2F3964760%2FConnectors%2Fc%2Fconnector-c-3.4.3%2Fmariadb-connector-c-3.4.3-win64.msi&product-name=C%20connector&download-size=16.15%20MB MariaDB ODBC 3.1 connector] (still using 3.1 for now since know it works).
*Launch the msi file and install with complete options

===Configure the ACP Assets===
*Add the Suan assets models with Mariadb compatible MYSQL calls to the UI folder.