MySQL libmysql Setup

Follow the Windows or Linux procedures below to setup the MySQL libmysql shared library on your machine.

Windows:

STEP 1: Download the MySQL MSI installer file

Go to the MySQL download site
Download the MSI installer file for the latest version of MySQL for Windows

Note: Iguana may not always support the very latest version of MySQL, so you can simply download an earlier version if necessary.

If you need to know which versions of MySQL are supported by the version of Iguana you are using please contact us at support@interfaceware.com.

STEP 2: Install the MySQL drivers

Double click the MSI file to open it. Click Yes to allow the installer to make changes on your machine.
Choose Client Only to install the client tools which includes the drivers and click Next.

Follow the remaining steps to finish installing the MySQL client tools:
- We strongly recommend accepting the default install values.
- Note: Do not configure MySQL Router — just click Finish.

STEP 3: Confirm IguanaX has detected and loaded the MySQL library in Settings > Database

In IguanaX, Settings > Database confirm the MySQL shared library has been detected and loaded correctly.

If not, click Edit to manually add the MySQL shared library for the version of MySQL you installed. If you don't know the location, you can search for the libmysql.dll

Linux:

STEP 1: Download MySQL (Linux - Generic)

Download MySQL from the MySQL download site.

Choose Linux - Generic from the Select Operating System dropdown.
Download the TAR archive file for the latest version of MySQL.

STEP 2: In terminal, install the libmysql driver

Unpack the TAR archive: this assumes file is <home>/Downloads, otherwise change the source path to match.

cd ~/Downloads   
tar xvf ~/Downloads/mysql–5.7.24–linux–glibc2.12–x86_64.tar.gz

Copy the driver to the drivers directory: this directory can differ on different versions of Linux.
- Ubuntu (Debian based) - use /usr/local/lib:
  
  Replace <version> to match the path where you unpacked the TAR file.
```
sudo cp ~/Downloads/mysql-\<version>-linux-glibc2.12-x86_64/lib/libmysqlclient.so* /usr/local/lib   
```
- CentOS (Redhat based) - use /usr/lib:
  
  Replace <version> to match the path where you unpacked the TAR file.
```
sudo cp ~/Downloads/mysql-\<version>-linux-glibc2.12-x86_64/lib/libmysqlclient.so* /usr/lib   
```

STEP 3: Confirm IguanaX has detected and loaded the MySQL library in Settings > Database

In IguanaX, Settings > Database confirm the MySQL shared library has been detected and loaded correctly.

If not, click Edit to manually add the MySQL shared library for the version of MySQL you installed. If you don't know the location, you can search for the libmysqlclient.so