Configure a Local MySQL Instance for Testing
This document describes how to run a MySQL instance locally with Docker and how to add it as an Instance for testing purpose.
Before starting, make sure you have installed Docker.
Step 1 - Start a local MySQL server in Docker
- Start Docker.
- 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
The setup below is for testing purpose and should NOT be used in production setup. Also the MySQL data will be wiped out after the container stops.
Step 2 - Add the MySQL Server as an Instance
- Click Instances on the top bar.
- Click Add Instance on the instances page, and you will see Create Instance dialog box.
- 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
- Click Create, and you can see the newly added instance in the table.