Connect to the database

There are two ways to connect to the database. Before you begin, you can find the database credentials in the database section of the docker/config.php file. The examples use the following default credentials:

Filename: docker/config.php

1
2
3
4
5
6
7
8
9
10
11
return [
    'MAGENTO_CLOUD_RELATIONSHIPS' => base64_encode(json_encode([
        'database' => [
            [
                'host' => 'db',
                'path' => 'magento2',
                'password' => 'magento2',
                'username' => 'magento2',
                'port' => '3306'
            ],
        ],

To connect to the database using Docker commands:

  1. Connect to the CLI container.

    1
    
    docker-compose run deploy bash
    
  2. Connect to the database with a username and password.

    1
    
    mysql --host=db --user=magento2 --password=magento2
    
  3. Verify the version of the database service.

    SELECT VERSION();
    +--------------------------+
    | VERSION()                |
    +--------------------------+
    | 10.0.38-MariaDB-1~xenial |
    +--------------------------+
    

To connect to the database:

  1. Find the port used by the database. The port may change each time you restart Docker.

    1
    
    docker-compose ps
    

    Sample response:

    1
    2
    3
    
              Name                         Command               State               Ports            
    --------------------------------------------------------------------------------------------------
    mc-master_db_1              docker-entrypoint.sh mysqld      Up       0.0.0.0:32769->3306/tcp   
    
  2. Connect to the database with port information from the previous step.

    1
    
    mysql -h127.0.0.1 -p32769 -umagento2 -pmagento2
    
  3. Verify the version of the database service.

    SELECT VERSION();
    +--------------------------+
    | VERSION()                |
    +--------------------------+
    | 10.0.38-MariaDB-1~xenial |
    +--------------------------+