Error: Unable to Validate Database User

Issue

While setting up a MySQL connector, the following error appears:

Unable to validate database user

Environment

Connector: MySQL

Resolution

To resolve this issue, do the following:

1. Ensure the Fivetran user you created has the appropriate permissions in your database. For more information on the permissions required, refer to the applicable MySQL connector's setup guide.

2. Ensure the username provided in the connection setup form is accurate and uses the correct capitalization.

   i. In Fivetran, go to your MySQL connection page.

   ii. Select the Setup tab.

   iii. Click Edit connection.

   iv. Check the username in the User field.

   v. If the username is incorrect, update it, then click Save & Test.

3. Ensure your MySQL database version is between 5.5 and 8.0. For more information, see our supported configurations for MySQL.

Cause

This issue may occur due to any of the following reasons:

• The configured user lacks the permission required to access the database.
• The username provided in the connection setup form is incorrect.
• The JDBC driver we use to connect to MySQL databases is incompatible with your MySQL version because it is a version lower than 5.5.