docker-compose rails mysql connection refused

Question

I face an issue while trying to make docker-compose contains Rails API and MySQL and others. After docker-compose up and send a request to the Rails API I get this error "#<Mysql2::Error::ConnectionError: Can't connect to MySQL server on 'database' (111 \"Connection refused\")>"

My docker-compose

services:
  database:
    image: mysql:8.0.23
    restart: always
    volumes:
      - 'db_data:/var/lib/mysql'
    environment:
      MYSQL_ROOT_PASSWORD: root
      MYSQL_USERNAME: root
      MYSQL_PASSWORD: root

  app:
    build: .
    restart: always
    depends_on:
      - 'database'
      - 'redis'
    ports:
      - '3000:3000'
    volumes:
      - '.:/app'
      - 'gem_cache:/usr/local/bundle/gems'
    env_file: .env
    environment:
      RAILS_ENV: development

database.yml

default: &default
  adapter: mysql2
  encoding: utf8
  host: <%= ENV['DATABASE_HOST'] %>
  port: <%= ENV['DATABASE_PORT'] || '5432' %>
  username: <%= ENV['DATABASE_USER'] %>
  password: <%= ENV['DATABASE_PASSWORD'] %>
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
  timeout: 5000

development:
  <<: *default
  database: <%= ENV['DATABASE_NAME_DEV'] %>
...

.env

...
DATABASE_HOST=database
...

What's the problem here?

Sibevin Wang · Accepted Answer · 2021-03-23 03:11:01Z

2

MySQL uses 3306 as the default port, and you should assign 3306 to the DATABASE_PORT environment.

edited Mar 23, 2021 at 3:11

answered Mar 21, 2021 at 12:50

Sibevin Wang

4,5683 gold badges31 silver badges27 bronze badges

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

2 Comments

Ahmed.aligokhy Over a year ago

Now I got this error Mysql2::Error::ConnectionError: Access denied for user 'root'@'172.22.0.4' (using password: NO)>

Sibevin Wang Over a year ago

Assign root to DATABASE_PASSWORD as well ?

Collectives™ on Stack Overflow

docker-compose rails mysql connection refused

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