MySQL Localhost Error - Localhost VS 127.0.0.1

This page is not yet available in Spanish. We are working on its translation.
If you have any questions or feedback about our current translation project, feel free to reach out to us!

Setting “localhost” in the mysql.yaml file may produce this error:

mysql
-----
- instance #0 [ERROR]: OperationalError(2003, 'Can\'t connect to
MySQL server on \'localhost\' ((1045, u"Access denied for user
\'datadog\'@\'127.0.0.1\' (using password: YES)"))')

The workaround is to grant permissions to datadog@127.0.0.1 , rather than datadog@localhost

This problem is documented in this closed Datadog Agent issue and referenced in the MySQL documentation