MySQL libmysql Setup

Owned by Aryn Wiebe
Last updated: Sept 23, 2024
2 min read

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

Windows:

  1. Go to the MySQL download site

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

  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.

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

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:

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

Â