MySQL for Hydra

Owned by Elena Sviridenko (Unlicensed)
Last updated: Oct 22, 2019 by Alexandr Kudentsov (Unlicensed)
2 min read


For a Windows connection, the appropriate database driver for Windows can be downloaded from http://dev.mysql.com/downloads/connector.

For a Unix/Linux connection, there are three main stages to complete:

  1. Install the iODBC driver manager
  2. Install the MySQL ODBC driver
  3. Set up the DSN. The iODBC driver manager for Unix/Linux platforms can be downloaded from http://www.iodbc.org by following the “downloads, cvs” link. The MySQL ODBC driver can be downloaded from:
    http://dev.mysql.com/
    and following the ‘MySQL Connector/ODBC’ link in the Downloads & Documentation list.

MySQL Windows Connection

For a standard Windows environment, select the Connector/ODBC link. On the next page select the Windows Downloads “Driver Installer (EXE)” mirror site link to download from.
Windows already includes an ODBC driver manager, so this does not need to be installed separately.

  1. From the Windows Start menu select the Run option, browse for the downloaded file “MyODBC-standard-9.99.9-win.exe” (where 9.99.9 is the version number), and run it.
  2. In the MyODBC Installation Wizard window, click the Next button.
  3. Read the License Agreement, and if you agree to its terms, select the “I accept the license agreement” radio button, and click the Next key.
  4. In the Readme Information window, click the Next button.
  5. In the Ready to Install the Application window, click the Next button. The installation process will begin. This should take about ten seconds to complete.
  6. When the installation is complete, click the Finish button.

MySQL Unix/Linux Connection

Installing the iODBC Driver Manager

The iODBC Driver Manager can be downloaded as an rpm file, or for older platform versions, a tar.gz file. You will need to build the driver manager. Download the appropriate file and copy it to your /usr directory. If you have a tar.gz file follow steps 1 to 3 and then continue at step 5, for an rpm file start at step 4.

  1. With the downloaded file in the /usr directory, unzip the file with the command: gunzip libiodbc-3.51.1.tar.gz
  2. Extract the files with the command: tar xvf libiodbc-3.51.1..tar
  3. Change directory to the newly created installation directory with the command: cd iodbc-3.51.1.
  4. For an rpm file, run the command: rpm –i file_name
  5. In the new directory run the command: ./configure
    The system will carry out a series of configuration functions.
  6. Run the command: make
  7. Run the command: make install

Installing the MySQL ODBC Driver

The MySQL ODBC driver can be downloaded as an rpm file or a tar.gz file.
Download the appropriate file and copy it to your /usr directory. If you have a .tar.gz file follow steps 1 to 3 and then continue at step 5, for a .rpm file start at step 4.

  1. With the downloaded file in the /usr directory, unzip the file with the command: gunzip MyODBC-3.51.09.tar.gz
  2. Extract the files with the command: tar xvf MyODBC-3.51.09.tar
  3. Change directory to the newly created installation directory with the command: cd MyODBC-3.51.09
  4. For a .rpm file, run the command: rpm –i file_name
  5. In the new directory run the command: ./configure
    The system will carry out a series of configuration functions.
    Run the command: make
  6. Run the command: make install
    This process has not been successfully completed by Querix and is thus untested.