Menu
Data2ServicesData2ServicesData2ServicesDocumentationBlogHelpContribute
🌜
🌞
Data2ServicesData2ServicesData2Services
  • Documentation
  • Blog
  • Help
  • Contribute
  • Publish data
    • Introduction
    • Installation
    • Create new dataset mappings
    • Choose a data model
    • Define RML mappings
    • Use Python
    • Deploy workflows
    • Store RDF data
    • Generate metadata
    • Publish FAIR data
    • RDF data validation
  • Deploy services
    • Recommended services
    • Additional services
    • Translator Prototypes
  • Use d2s CLI
    • Introduction to d2s
    • Installation
    • Initialize and update
    • Start services
    • Start services
    • Graph databases
    • Interfaces
    • Utilities
    • Add a new dataset
    • Run RML transformations
    • Run CWL workflows
    • Use Monarch Dipper
    • Use BioThings Studio
    • Use OTTR templates
  • Guides
    • Preprocess input files
    • Docker guide
    • Experimental Jenkins workflows
    • Setup databases
      • Setting up GraphDB
      • Setting up Virtuoso
      • Setting up PostgreSQL
      • Setting up MariaDB
      • Setting up MySQL
    • Translator Standards
  • Kubernetes workflows
    • Argo installation
    • Login to OpenShift
    • Define volumes
    • Run Argo workflows
    • Argo commands
    • Debug Argo workflow
    • Use OpenShift secrets

Setting up MySQL

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

Run MySQL database#

docker run --name mysql-db -e MYSQL_ROOT_PASSWORD=pwd -d mysql

Password is pwd

Connect to MySQL#

docker exec -it mysql-db mysql -uroot -ppwd

MySQL commands#

SHOW DATABASES;
CREATE DATABASE database_name;
USE database_name;
SELECT * FROM database_name LIMIT 10;
Edit this page
Last updated on 2/2/2021 by Vincent Emonet
Previous
« Setting up MariaDB
Next
Translator Standards »
  • Run MySQL database
  • Connect to MySQL
  • MySQL commands
cc by license
Copyright © 2021 Institute of Data Science at Maastricht University
We track page views and users demographics using Google Analytics to improve our users experience. See how Google uses collected informations.
You can prevent Google Analytics tracking by enabling Firefox Tracking Protection, installing uBlock Origin add-on, or using the official Google Analytics Opt-out add-on.