How can I connect the database instance I created with docker compose?

Ant243nSoaresRial
March 2, 2022
279 views
0 votes
2 Answers

I’m trying to program a simple python app (following this tutorial) and I want to use a MySQL database created with docker but I’m getting some problems.

There is my docker-compose.yml:

version: '3.7'
services:
  backend:
    build:
      context: .
      dockerfile: Dockerfile
    command: 'python manage.py runserver 0.0.0.0:8000'
    ports:
      - '8000:8000'
    volumes:
      - .:/app
    depends_on:
      - db
  db:
    image: mysql:5.7.22
    restart: always
    environment:
      MYSQL_DATABASE: admin
      MYSQL_USER: root
      MYSQL_PASSWORD: root
      MYSQL_ROOT_PASSWORD: root
    volumes:
      - .dbdata:/var/lib/mysql
    ports:
      - '33077:3306'

I can run the docker-compose up and it looks good. docker-compose ps output:

     Name                    Command               State                     Ports                   
-----------------------------------------------------------------------------------------------------
admin_backend_1   python manage.py runserver ...   Up      0.0.0.0:8000->8000/tcp,:::8000->8000/tcp  
admin_db_1        docker-entrypoint.sh mysqld      Up      0.0.0.0:33077->3306/tcp,:::33077->3306/tcp

Then, I’m trying to connect with user:root and password:root at localhost:33077 and I receive this error. Could you give me some help?

When I execute docker-compose up I get this:

Starting admin_db_1 ... done
Starting admin_backend_1 ... done
Attaching to admin_db_1, admin_backend_1
db_1       | 2022-03-02T12:26:20.204261Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
db_1       | 2022-03-02T12:26:20.205273Z 0 [Note] mysqld (mysqld 5.7.22) starting as process 1 ...
db_1       | 2022-03-02T12:26:20.207089Z 0 [Note] InnoDB: PUNCH HOLE support available
db_1       | 2022-03-02T12:26:20.207104Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db_1       | 2022-03-02T12:26:20.207105Z 0 [Note] InnoDB: Uses event mutexes
db_1       | 2022-03-02T12:26:20.207107Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
db_1       | 2022-03-02T12:26:20.207108Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
db_1       | 2022-03-02T12:26:20.207109Z 0 [Note] InnoDB: Using Linux native AIO
db_1       | 2022-03-02T12:26:20.207250Z 0 [Note] InnoDB: Number of pools: 1
db_1       | 2022-03-02T12:26:20.207316Z 0 [Note] InnoDB: Using CPU crc32 instructions
db_1       | 2022-03-02T12:26:20.208157Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
db_1       | 2022-03-02T12:26:20.212058Z 0 [Note] InnoDB: Completed initialization of buffer pool
db_1       | 2022-03-02T12:26:20.213177Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
db_1       | 2022-03-02T12:26:20.224331Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
db_1       | 2022-03-02T12:26:20.232279Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db_1       | 2022-03-02T12:26:20.232321Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db_1       | 2022-03-02T12:26:20.264177Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db_1       | 2022-03-02T12:26:20.264599Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
db_1       | 2022-03-02T12:26:20.264604Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
db_1       | 2022-03-02T12:26:20.264790Z 0 [Note] InnoDB: Waiting for purge to start
db_1       | 2022-03-02T12:26:20.315127Z 0 [Note] InnoDB: 5.7.22 started; log sequence number 12359913
db_1       | 2022-03-02T12:26:20.315447Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db_1       | 2022-03-02T12:26:20.315686Z 0 [Note] Plugin 'FEDERATED' is disabled.
db_1       | 2022-03-02T12:26:20.317675Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220302 12:26:20
db_1       | 2022-03-02T12:26:20.322304Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
db_1       | 2022-03-02T12:26:20.322594Z 0 [Warning] CA certificate ca.pem is self signed.
db_1       | 2022-03-02T12:26:20.326271Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
db_1       | 2022-03-02T12:26:20.326318Z 0 [Note] IPv6 is available.
db_1       | 2022-03-02T12:26:20.326330Z 0 [Note]   - '::' resolves to '::';
db_1       | 2022-03-02T12:26:20.326346Z 0 [Note] Server socket created on IP: '::'.
db_1       | 2022-03-02T12:26:20.331099Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
db_1       | 2022-03-02T12:26:20.332360Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode.
db_1       | 2022-03-02T12:26:20.332405Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode.
db_1       | 2022-03-02T12:26:20.332422Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode.
db_1       | 2022-03-02T12:26:20.332457Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode.
db_1       | 2022-03-02T12:26:20.332466Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode.
db_1       | 2022-03-02T12:26:20.332482Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode.
db_1       | 2022-03-02T12:26:20.335750Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode.
db_1       | 2022-03-02T12:26:20.335772Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode.
db_1       | 2022-03-02T12:26:20.342036Z 0 [Note] Event Scheduler: Loaded 0 events
db_1       | 2022-03-02T12:26:20.342204Z 0 [Note] mysqld: ready for connections.
db_1       | Version: '5.7.22'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
backend_1  | Watching for file changes with StatReloader
backend_1  | Performing system checks...
backend_1  | 
backend_1  | System check identified no issues (0 silenced).
backend_1  | 
backend_1  | You have 18 unapplied migration(s). Your project may not work properly until you apply the migrations for app(s): admin, auth, contenttypes, sessions.
backend_1  | Run 'python manage.py migrate' to apply them.
backend_1  | March 02, 2022 - 12:26:20
backend_1  | Django version 4.0.2, using settings 'admin.settings'
backend_1  | Starting development server at http://0.0.0.0:8000/
backend_1  | Quit the server with CONTROL-C.