Sign inSign up

slashdb/test-mysql

By slashdb

Updated over 8 years ago

Image
0

65

slashdb/test-mysql repository overview

This Docker image contains MySQL 5.7 server with already installed Chinook database. This may can come handy when testing SlashDB.

The easiest way to set everything up is by using docker-compose that creates common network for containers.

First download default SlashDB configs and unzip it

wget https://downloads.slashdb.com/latest/default-slashdb-configs.zip
unzip default-slashdb-configs.zip

This created ./slashdb directory, which will be attached to SlashDB to persist changes in configuration.

Next in current folder create a file docker-compose.yml looking like that.

vi docker-compose.yml

put below config into that file

version: '2'
services:  
  slashdb-mysql:
    container_name: slashdb-mysql
    image: slashdb/test-mysql:5.7
    ports:
      - 3308:3306
  slashdb:
    container_name: slashdb
    image: slashdb/slashdb
    ports:
      - "8000:80"
    volumes:
      - ./slashdb:/etc/slashdb
    depends_on:
      - slashdb-mysql```

Create containers with

```docker-compose up -d```

MySQL users:
**root** with password: **root**.
**chinook** with password: **chinook**

When it's ready. Visit http://localhost:8000 using your browser to configure SlashDB.

Check documentation on how to log in for the first time https://docs.slashdb.com/user-guide/config-databases.html and how to add database https://docs.slashdb.com/user-guide/configuration.html

Since SlashDB and MySQL are in the same network use below values when configuring database:

**Type:** mysql
**Database Charset:** utf-8
**Database Schema:** [leave it empty]
**Database Host:**  slashdb-mysql
**Database Port:** 3306
**Database Name:** Chinook
**Database Login**: chinook
**Databse Passwrod**: chinook
Tick **Use Credentials for Current User**.

Tag summary

Content type

Image

Digest

Size

100.8 MB

Last updated

over 8 years ago

docker pull slashdb/test-mysql:5.7