Difference between revisions of "ACP with Mariadb"

(Created page with "Steps to setup teh ACP databse for use with Mariadb *Install MariaDB *Install the MariaDB ODBC driver *Add the Suan assets models with Mariadb compatible MYSQL calls to the U...")
 
Line 1: Line 1:
−
Steps to setup teh ACP databse for use with Mariadb
+
Steps to setup the ACP databse 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
 +
*Click new session at bottom left
 +
**<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]
  
−
*Install MariaDB
 
 
*Install the MariaDB ODBC driver
 
*Install the MariaDB ODBC driver
 
*Add the Suan assets models with Mariadb compatible MYSQL calls to the UI folder.
 
*Add the Suan assets models with Mariadb compatible MYSQL calls to the UI folder.

Revision as of 15:45, 9 January 2025

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.
Comments


You are not allowed to post comments.