Environment configuration not working for Mysql 8 docker image

Build Environment
,
1

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