Making the MySQL Database Option Visible in Windows
Installation Notes
You must have MySQL installed and the system PATH must be set correctly to ensure that the MySQL database option is visible in the API drop-down menu.
Unsupported MySQL Versions
Note that MySQL 5.0.41 is not supported by Iguana because of a defect in MySQL; more specifically, MySQL 5.0.41 is unable to dynamically load libmysql.dll. For details, see MySQL's website at http://bugs.mysql.com/bug.php?id=28358.
Windows 2000 Screenshots
The screenshots in this section are from Windows 2000 - the screens will be similar but slightly different for Windows XP or later operating systems. However, note that iNTERFACEWARE does not advise using Windows ME or Windows 98 for running important, mission-critical server applications.
To make the MySQL database option visible:
Click Start > Settings > Control Panel > System. The System Properties window appears.
System Properties window
Click the Advanced tab > Environment Variables. The Environment Variables window appears.
Under System Variables, scroll down and highlight Path, and click Edit. The Edit System Variable window appears.
Edit System Variable window
In the above example, the path of the libmysql.dll file is C:\mysql\bin. However, the actual path for your libmysql.dll file may vary if mysql has been installed in a different directory.
Add the location of your libmysql.dll file to the Variable Value field of the system PATH. Make sure to separate the path from the last value with a semi-colon as shown above.
Once the path has been set, click OK to save your changes.
Restart your computer for the changes to take effect. The MySQL database option should now be visible in the API drop-down menu.