Can't connect to database with docker

Question

Trying to connect to my database via Sequel Pro but it either doesn't recognise the host or there's an error:

MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found

docker-compose

version: "3"
services:

  my_database:
    image: mysql:5.7.30
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: my_root
      MYSQL_DATABASE: my_wp_database
      MYSQL_USER: my_wp_user
      MYSQL_PASSWORD: my_wp_user_password
    volumes:
      - mysql:/var/lib/mysql

  wordpress:
    depends_on:
      - my_database
    image: wordpress:latest
    restart: always
    ports:
      - "8000:80"
    environment:
      VIRTUAL_PORT : 8000
      WORDPRESS_DB_HOST: my_database:3306
      WORDPRESS_DB_USER: my_wp_user
      WORDPRESS_DB_PASSWORD: my_wp_user_password
      WORDPRESS_DB_NAME: my_wp_database
    volumes:
      ["./:/var/www/html"]
volumes:
  mysql: {}

At first I thought it was the mysql version as I was using latest so I changed to 5.7.30.

I had used the code from a tutorial to get a wordpress site up and running which it does but I just don't seem to be able to use any database client.

I tried the following credentials:

127.0.0.1 (also 0.0.0.0) root my_root

127.0.0.1 (also 0.0.0.0) my_wp_database my_wp_user_password

Can't connect to database with docker

0 Answers0