MySQL Errors and Troubleshooting

Issue

You're experiencing problems with our software that are related to your ability to connect to the MySQL database.

When installed properly, the Land F/X components function together cleanly and efficiently. Due to the software's need for MySQL connectivity, many performance problems will result from network configuration or permissions issues.

Solution

Initial MySQL Troubleshooting

The first steps in tracking down any issues with MySQL would be:

1. Verify that the System account (MySQL) and all users have full read/write permissions to the LandFX folder.

2. Verify that MySQL on the server is running and set to "automatic."

3. Verify that Port 3306 is not blocked by any firewalls or anti-virus software. If necessary, create a Windows Firewall exception for Port 3306.

4. Verify the workstations are all using the correct settings in their ODBC entries by Troubleshooting Their ODBC Connections.

Specific MySQL Issues & Errors

Here are some potential MySQL issues, with links to their solutions:

• Unable to connect to F/X Database
• Error 1067 – When Starting Service
• Error: Failure to Lookup Driver Entry at Path 'C:\program files\MySQL\Connector ODBC 5.1\myodbc5.dll'
• Your issue may also be the result of a slow connection to the Land F/X database.