Setting up MariaDB

Not integrated to the d2s client at the moment, let us know if you would need it to be integrated.

Run MariaDB

docker run --rm --name mariadb -v $(pwd)/workspace/mariadb:/data -e MYSQL_ROOT_PASSWORD=pwd -d mariadb

Shared on your machine at /data/d2s-workspace

Password ispwd

Connect to MySQL

docker exec -it mariadb mysql -uroot -ppwd

MySQL commands

SHOW DATABASES;

CREATE DATABASE database_name;

USE database_name;

SHOW TABLES;

SELECT * FROM table_name LIMIT 10;

Load scripts

docker exec -i mariadb mysql -uroot -ppwd database_name < /data/load_data.sql

JDBC URL

jdbc:mariadb://localhost:3306/DB?user=root&password=pwd