What are the Slack Archives?

It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.

Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..

Hi there, how can I connect to the database in the b2c-demo-shop on the commandline?

U018XELUZS9
U018XELUZS9 Posts: 167 πŸ§‘πŸ»β€πŸš€ - Cadet

Hi there, how can I connect to the database in the b2c-demo-shop on the commandline?

Comments

  • U01T075RRHD
    U01T075RRHD Posts: 118 πŸ§‘πŸ»β€πŸš€ - Cadet
    docker/sdk cli mariadb -h database -u spryker -p
    

    For MariaDB

  • U01T075RRHD
    U01T075RRHD Posts: 118 πŸ§‘πŸ»β€πŸš€ - Cadet

    User depends on your local configuration, of course

  • U018XELUZS9
    U018XELUZS9 Posts: 167 πŸ§‘πŸ»β€πŸš€ - Cadet

    Thanks, it worked now with this command:

    docker/sdk cli mariadb -u spryker -psecret -h database eu-docker
    

    I found the credentials like so:

    $ grep SPRYKER_DB_ docker/deployment/default/env/cli/de.env | grep -v ROOT
    SPRYKER_DB_ENGINE=mysql
    SPRYKER_DB_HOST=database
    SPRYKER_DB_PORT=3306
    SPRYKER_DB_DATABASE=eu-docker
    SPRYKER_DB_USERNAME=spryker
    SPRYKER_DB_PASSWORD=secret
    SPRYKER_DB_CHARACTER_SET=utf8
    SPRYKER_DB_COLLATE=utf8_general_ci
    
  • U018XELUZS9
    U018XELUZS9 Posts: 167 πŸ§‘πŸ»β€πŸš€ - Cadet