To run script which creates database and set privileges execute commands below: Once load mysql: docker pull mysql:latest Install Database Navigator plugin and connects to mysql: root pass, DB see in command below, user:root. Pay attention to port, it needs to set as in command below, or use your own. When starts to work: If didn't remove container in previous session. remove it now docker stop mysql_local_qa docker rm mysql_local_qa docker run -d --name mysql_local_qa -e MYSQL_ROOT_PASSWORD=1234 -e MYSQL_DATABASE=db -e MYSQL_USER=user -e MYSQL_PASSWORD=password -p 3310:3306 mysql:latest Just a check, execution is optional: docker ps --filter name=mysql_local_qa --format "table {{.Names}}\t{{.Status}}" Copy in a docker container and execute file which creates the database and table inside + sets privileges. docker cp .\init.sql mysql_local_qa:/init.sql cmd docker exec -i mysql_local_qa mysql -u root -p1234 < init.sql When you finished work or before each session if didn't do it in previous: docker stop mysql_local_qa docker rm mysql_local_qa
Liquibase, command below need to run each time after docker container was up(commands above).
To run database changeset in Maven console run mvn clean package or setup mvn util for terminal, maybe need just set Environmental variables.
Liquibase config see in liquibase.properties file in resources.
mvn clean package will start execute list of changes in db/changelog/db.changelog-master.yaml,
mvn liquibase:rollback -Dliquibase.propertyFile=src/main/resources/liquibase.properties -Dliquibase.rollbackCount=1