MySQL Connection Validation Failure: Troubleshooting and Solutions

MySQL Connection Validation Failure

KB ID: 113003
Issue:
Connection validation for MySQL has failed due to an issue encountered during the configuration of the DSN (Data Source Name), user name, or password.
Solution:
To address this issue, please follow the steps below:
1. Execute the following command:
isql -v [DSN Name] [User Name] [Password]
2. Check if you are able to successfully connect to the MySQL Server using the provided DSN, username, and password.
3. If the connection is unsuccessful, reevaluate the DSN, username, and password settings that you specified during the configuration process.
This knowledge base article provides guidance on resolving MySQL connection validation failures