MySQL Localhost Error - Localhost VS 127.0.0.1

このページは日本語には対応しておりません。随時翻訳に取り組んでいます。翻訳に関してご質問やご意見ございましたら、お気軽にご連絡ください。

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