Share

Installing and configuring the MySQL Client on Windows

Technical Support

Issue:

You want to know how to install and configure the MySQL Client on Windows.

Solution:

The new version of FDO installed with MapGuide Enterprise 2009 requires that the MySQL 5.0.27 database also be installed. Your server administrator will have to upgrade the MySQL instance to this version if an earlier version is currently installed.

To connect to the database, copy the libmysql.dll file contained in the MySQL installation folder to the following folder on your computer: C:\Program Files\Autodesk\MapGuideEnterprise2009\Server\Bin\Fdo

Note: The libmysql.dll file from later versions of MySQL may not work with FDO. 

If you are running the MySQL instance on the same computer as MapGuide Enterprise (which is not recommended), you can reference the libemysql.dll file by adding the path of the MySQL installation folder to the System PATH variable and then restarting the MapGuide server.

If you do not have access to the database server, you can perform a temporary installation of MySQL in order to obtain the DLL file. Follow these steps:

  1. Download MySQL 5.0.27 from this webpage.
  2. Install MySQL with the default settings.
  3. Locate the libmysql.dll file in the MySQL installation folder and copy it to the following folder: C:\Program Files\Autodesk\MapGuideEnterprise2009\Server\Bin\Fdo
  4. Temporarily rename the MySQL installation folder.
  5. Attempt to connect to the MySQL database from MapGuide Studio 2009.
  6. Once you have confirmed that a successful connection can be made, revert the folder to its original name and uninstall MySQL.

If you wish, you can install the MySQL ODBC 3.51 Connector, available from this webpage.

Note: Versions up to and including 3.51.16 may work. Version 3.5.17 does not work. Version 3.5.20 does work.

Products:

MapGuide Enterprise; All Desktop Products;

Versions:

2009;

Was this information helpful?