Directus is not connecting with mysql over SSH server

Question

I can't connect my directus project with mysql server. Getting connection refused error.

However when I'm running this command, I'm able to connect: mysql -u root -p -h localhost -P 3306

My docker-compose.yml file:

version: '3'
services:
 directus:
  container_name: directus
  image: directus/directus:latest
  ports:
    - 8055:8055
  environment:
   KEY: 'KEY_VALUE'
   SECRET: 'SECRET_VALUE'
   DB_CLIENT: 'mysql'
   DB_HOST: 'localhost'
   DB_PORT: '3306'
   DB_DATABASE: 'directus'
   DB_USER: 'root'
   DB_PASSWORD: 'MYSQL_PASSWORD'
   MYSQL_ROOT_PASSWORD: 'MYSQL_PASSWORD'
   MYSQL_USER: 'root'
   MYSQL_PASSWORD: 'MYSQL_PASSWORD'
   MYSQL_DATABASE: 'directus'
   ADMIN_EMAIL: '[email protected]'
   ADMIN_PASSWORD: 'admin'
 networks:
  directus:

Lalarukh khan · Accepted Answer · 2024-07-22 13:11:09Z

2

I actually faced the same issue and after terrible search finally I made the solution.

You can connect to mysql by using this modified code:

version: '3.8'
services:
 mysql:
  image: mysql:5.7
  container_name: mysql
  restart: always
  environment:
   MYSQL_ROOT_PASSWORD: 'MYSQL_PASSWORD'
   MYSQL_DATABASE: 'directus'
  ports:
   - "3306:3306"

 directus:
  image: directus/directus:latest
  container_name: directus
  restart: always
  ports:
   - "8055:8055"
  environment:
   KEY: 'KEY_VALUE'
   SECRET: 'SECRET_VALUE'
   DB_CLIENT: 'mysql'
   DB_HOST: 'mysql'
   DB_PORT: '3306'
   DB_DATABASE: 'directus'
   DB_USER: 'root'
   DB_PASSWORD: 'MYSQL_PASSWORD'
   ADMIN_EMAIL: '[email protected]'
   ADMIN_PASSWORD: 'admin'
  depends_on:
   - mysql

networks:
 default:
  name: directus_network

edited Jul 22, 2024 at 13:11

answered Jul 21, 2024 at 14:51

Lalarukh khan

17010 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

joanis Over a year ago

You just shared your password, key and secret with the world. Please invalidate and change them ASAP.

user2399035 Over a year ago

the edit you made is still visible in the history...

Collectives™ on Stack Overflow

Directus is not connecting with mysql over SSH server

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related