Tutorial: Change the Database Backend to MySQL or Amazon RDS with the Admin Web UI
Overview
Access Server can store configuration in MySQL-type database systems such as Amazon RDS, MySQL, and MariaDB.
By default, Access Server creates configuration files in a SQLite3 database on the server. This tutorial shows you how to convert to a separate database server.
If you set up a cluster of Access Servers, all of your Access Servers will connect to one database system to share configuration. You may even set this up with a cluster of database servers to create a truly fault-tolerant system. Refer to Tutorial: How to Set Up an Access Server Cluster for details.
Prerequisites
An installed Access Server.
A supported database server.
OS vs RDBMS Compatibility (Access Server 3.2.x)
Compatibility validated against representative patch releases within each version family.
OS | MySQL 5.7.x | MySQL 8.0.x | MySQL 8.4.x | MySQL 9.x | MariaDB 10.11.x | MariaDB 11.x |
|---|---|---|---|---|---|---|
Ubuntu 22.04 (x86_64) | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
Ubuntu 22.04 (ARM64) | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
Ubuntu 24.04 (X86_64) | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
Ubuntu 24.04 (ARM64) | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
Ubuntu 26.04 (X86_64) | X | ✓ | ✓ | ✓ | ✓ | ✓ |
Debian 12 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
Debian 13 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
Red Hat 8 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
Red Hat 9 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
Red Hat 10 | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |
Some RHEL releases shipped with MariaDB C and ODBC connector builds that exhibited compatibility issues. These have been resolved through subsequent updates or documented configuration adjustments. Refer to the MariaDB connector documentation for version-specific details.