Mysql 8.0 not working with Ghost stack in CE 2.20.3

[robetus]

I'm trying to run a ghost blog stack in Portainer CE 2.20.3 and mysql:5.7 which is now depreciated is working fine but mysql:8.0 won't work. The ghost blog application is confirmed working with 8.0 but it won't running as a stack inside Portainer. Here is my compose file:

services:

  ghost:
    image: ghost:latest
    restart: always
    ports:
      - 8080:2368
    depends_on:
      db:
        condition: service_healthy
    environment:
      # see https://ghost.org/docs/config/#configuration-options
      database__client: mysql
      database__connection__host: db
      database__connection__user: "mysql"
      database__connection__password: "some_pass"
      database__connection__database: "ghostdb"
      url: https://mydomain.com
      mail__from: [email protected]
      mail__transport: SMTP
      mail__options__host: email-smtp.us
      mail__options__port: 465
      mail__options__auth__user: "smtp_user"
      mail__options__auth__pass: "smtp_user_pass"
      mail__options__secure_connection: true

    volumes:
      - /srv/mounted_drive/ghost/content:/var/lib/ghost/content

  db:
    image: mysql:8.0
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: some_root_pass
      MYSQL_DATABASE: ghostdb
      MYSQL_USER: mysql
      MYSQL_PASSWORD: some_pass
    volumes:
      - /srv/mounted_drive/ghost/db:/var/lib/mysql
    healthcheck:
      test: ["CMD-SHELL", "mysqladmin ping -h localhost -u $$MYSQL_USER --password=$$MYSQL_PASSWORD && mysql -u $$MYSQL_USER --password=$$MYSQL_PASSWORD -e 'SHOW DATABASES LIKE \"$$MYSQL_DATABASE\";'"]
      interval: 30s
      timeout: 10s
      retries: 5

volumes:
  ghost:
  db:

The version line was removed because Portainer told me it was no longer needed. If I change mysql:8.0 to mysql:5.7 it works every time but any 8.x version will not work. I've tried many, I've also tried latest. Is it just portainer? Can this be fixed/updated in a future update? I don't want to use mysql 5.7.

[Nick-Portainer]

What error do you get? I am using Ghost and have it running 8.0 deployed via Portainer just fine. Here is my compose

services:

  ghost:
    image: ghost:latest
    restart: always
    ports:
      - 3011:2368
    environment:
      # see https://ghost.org/docs/config/#configuration-options
      database__client: mysql
      database__connection__host: db
      database__connection__user: root
      database__connection__password: password
      database__connection__database: ghost
      # this url value is just an example, and is likely wrong for your environment!
      url: https://my_url
      # contrary to the default mentioned in the linked documentation, this image defaults to NODE_ENV=production (so development mode needs to be explicitly specified if desired)
      #NODE_ENV: development
    volumes:
      - ghost-content:/var/lib/ghost/content
  db:
    image: mysql:8.0
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: password
    volumes:
      - ghost-db:/var/lib/mysql
volumes:
  ghost-db:
  host-content:

[robetus]

Apologies, didn't update this.

I got it working.

I’m running a Portainer VM on Proxmox and I needed to change my CPU type to host because mysql 8 gives an error if not:

Fatal glibc error: CPU does not support x86-64-v2

Then the database created itself but the ghost container would not start for about 10 minutes because I read it can take time for the database to build itself.

Everything is working now with mysql 8 and the latest ghost. This was my exact issue, hopefully others will find it usual if they're using the same setup. This can be closed/solved.

[robetus]

I closed it but it's being shown as unanswered, maybe you can change it to answered.