# Environment configuration not working for Mysql 8 docker image

**URL:** <https://discuss.circleci.com/t/environment-configuration-not-working-for-mysql-8-docker-image/35226>\
**Category:** Build Environment\
**Tags:** mysql, circle-yml\
**Created:** [April 1, 2020, 4:22pm UTC](https://discuss.circleci.com/t/environment-configuration-not-working-for-mysql-8-docker-image/35226 "2020-04-01T16:22:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![rcapile](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/rcapile/32/21118_2.png) [@rcapile](https://discuss.circleci.com/u/rcapile)\
**Post date:** [April 1, 2020, 4:22pm UTC](https://discuss.circleci.com/t/environment-configuration-not-working-for-mysql-8-docker-image/35226/1 "2020-04-01T16:22:59Z")

</div>

I cannot connect to mysql using MySQL 8. When using 5.7 it works without any problem (config truncated)

> ```
> version: 2.1
> 
> commands:
> run-tests:
> steps:
> - checkout
> - run:
> name: Test connection
> command: |
> mysql -h 127.0.0.1 -u bycUser -pbycPass byc_test -e ";"
> 
> jobs:
> main:
> docker:
> - image: circleci/php:7.4
> #- image: circleci/mysql:8.0.4
> - image: circleci/mysql:5.7
> environment:
> MYSQL_ROOT_PASSWORD: bycRoot
> MYSQL_DATABASE: byc_test
> MYSQL_USER: bycUser
> MYSQL_PASSWORD: bycPass
> 
> working_directory: ~/repo
> 
> steps:
> - run-tests
> 
> workflows:
> version: 2
> tests:
> jobs:
> - main
> 
> ```

When using Mysql 8 it returns the error

> #!/bin/bash -eo pipefail mysql -h 127.0.0.1 -u bycUser -pbycPass byc\_test -e “;”
> 
> ERROR 1045 (28000): Plugin caching\_sha2\_password could not be loaded: /usr/lib/x86\_64-linux-gnu/mariadb19/plugin/caching\_sha2\_password.so: cannot open shared object file: No such file or directory Exited with code exit status 1
> 
> CircleCI received exit code 1