Database

Database

The Settings Database page allows you to configure the database driver libraries for Iguana.

  1. Iguana uses three database APIs: MySQL, Oracle OCI and Open Database Connectivity (ODBC).

  2. Iguana automatically detects the latest installed drivers, in most cases you will not need to change these settings. You can manually choose a different library if required.

How does Iguana find shared libraries?

  1. It searches the Windows registry for installed libraries.

  2. Otherwise, it checks directories in the system search path.

Note: If connecting to MySQL 8+ using the MySQL native driver, you may need to add the bin directory from the MySQL installation to the system PATH for the driver to work. For a standard install on Windows, this is C:\Program Files\MySQL\MySQL Server 8.4\bin

Note: When connecting to MySQL on an M-series Mac you need an x86 version of the driver

  • Download the MySQL x86 TAR Archive (not the DMG installer)

  • Extract the archive and locate the driver: libmysqlclient.24.dylib

  • Place the driver in a separate directory and reference it explicitly in database settings

    • Do not copy the x86 driver into the (ARM) MySQL library directory — it may cause conflicts or be ignored

  • The Mariadb x86 connector driver also works as a drop-in replacement

  • NOTES:

    • This is because IguanaX is an intel Binary that runs using Rosetta emulation

    • Earlier versions of macOS worked with the ARM driver, but Apple has tightened Rosetta emulation rules in recent versions (so now the Intel driver is needed)