MySQL libmysql Setup

1. Go to the MySQL download site

2. Download the MSI installer file for the latest version of MySQL for Windows

1. Double click the MSI file to open it. Click Yes to allow the installer to make changes on your machine.

2. Choose Client Only to install the client tools which includes the drivers and click Next.

Open

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

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

Open

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

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.

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

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