# Circleci/mysql: Authentication plugin 'caching\_sha2\_password' cannot be loaded

**URL:** <https://discuss.circleci.com/t/circleci-mysql-authentication-plugin-caching-sha2-password-cannot-be-loaded/21900>\
**Category:** Databases\
**Tags:** mysql\
**Created:** [April 23, 2018, 10:50am UTC](https://discuss.circleci.com/t/circleci-mysql-authentication-plugin-caching-sha2-password-cannot-be-loaded/21900 "2018-04-23T10:50:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![simena86](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/simena86/32/17760_2.png) [@simena86](https://discuss.circleci.com/u/simena86)\
**Post date:** [April 23, 2018, 10:50am UTC](https://discuss.circleci.com/t/circleci-mysql-authentication-plugin-caching-sha2-password-cannot-be-loaded/21900/1 "2018-04-23T10:50:26Z")

</div>

We’ve just recently got into trouble with all our tests because of an error when running `mysql --host 127.0.0.1`:

`ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: Error loading shared library /usr/lib/mysql/plugin/caching_sha2_password.so: No such file or directory Exited with code 1`

Parts of our config.yml:

```auto
jobs:
  build:
    environment:
    docker:
      - image: circleci/mysql:5.5
      - image: rabbitmq:3-alpine
      ...
    working_directory: ~/webapp

    steps:
      ...
      - run:
          name: Prepare DB
          command: echo "create database" | mysql --host 127.0.0.1

```

This did only occured the last couple of days, and we did not make any changes related to circle or mysql.  
Any idea how to fix this?

---

<div class="post-metadata">

**Author:** ![halfer](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/halfer/32/9083_2.png) [@halfer](https://discuss.circleci.com/u/halfer)\
**Post date:** [April 23, 2018, 11:22am UTC](https://discuss.circleci.com/t/circleci-mysql-authentication-plugin-caching-sha2-password-cannot-be-loaded/21900/2 "2018-04-23T11:22:45Z")

</div>

I don’t use `circleci/mysql:5.5`, but something to try: track down the source of it on GitHub, and see if some changes have been made to it recently. You could try pinning to a specific digest instead of the general version 5.5, since presently you’d be pulling any patch-level changes with every build.

And, of course, if you get completely stuck, try a different MySQL image from Docker Hub, or roll your own. I expect a basic MySQL server on Alpine is 10 lines or so in a Dockerfile.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/circleci/original/3X/5/1/511608acda8e85906e15909b57bd0a46c1dbe291.png) [@system](https://discuss.circleci.com/u/system)\
**Post date:** [July 22, 2018, 11:27am UTC](https://discuss.circleci.com/t/circleci-mysql-authentication-plugin-caching-sha2-password-cannot-be-loaded/21900/3 "2018-07-22T11:27:08Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.