Jitterbit · Database connector (MySQL)

MySQL: Access denied for user

Short answer

This Jitterbit MySQL error can appear with correct credentials, because MySQL can grant different privileges depending on the client IP address. In MySQL, verify the user has the necessary grants for the private agent's IP address.

VerifiedLast verified

01Error text

Jitterbit error
Access denied for user 'root'@'%' to database 'test'

02Likely causes

  • MySQL can grant different privileges depending on the client IP address. The user may have the required privileges from some IPs but not from the private agent's IP.

03How to fix it

  1. In MySQL, verify the user has the necessary grants for the private agent's IP address.
  2. Test connectivity with a MySQL client installed on the agent host to tell network problems from Jitterbit-specific ones.

04Official documentation

Test every fix in a non-production environment before you apply it to production. See how entries are verified.

More for Jitterbit work:Open Jitterbit jobsJitterbit rates and salaries

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.