Run a Local MySQL Instance

This document describes how to run a MySQL instance locally with Docker and how to add it as an Instance for testing purpose.

Step 1 - Start a local MySQL server in Docker#

1. Start Docker.
2. Run the command in the terminal

docker run --name mysqld \
  --publish 3306:3306 \
  -e MYSQL_ROOT_HOST=172.17.0.1 \
  -e MYSQL_ROOT_PASSWORD=testpwd1 \
  mysql/mysql-server:8.0

Step 2 - Add the MySQL Server as an Instance#

1. Click Instances on the top bar.
2. Click Add Instance on the instances page, and you will see Create Instance dialog box.
3. Fill the fields as follows:

• Choose MySQL
• Instance Name: MySQL Docker for Test
• Environment: Test
• Host or Socket: host.docker.internal
• Port: 3306
• Username: root
• Password: testpwd1

4. Click Create, and you can see the newly added instance in the table.