MYSQL container setup смотреть онлайн

Setting up a container with mysql as well as connecting it to a Spring boot API server.


I go through all the sets required to get this up and running (minus initial docker setup).


Remember to run your api server after setting it up to populate data (assuming you are using SQL queries on startup, or something like Flyway for migrations)

-- Here are the commands I used during this demo:
*Feel free to change "volume-name", "container-name", database-name", "mysqlroot-pswd", "mysql-pswd" to whatever you want (or is valid for you setup/project)


#volume setup:
` docker volume create "volume_name" `
for example:
` docker volume create mysql-data `


#container setup:
` docker run -d -v "volume-name":/var/lib/mysql -p 3306:3306 --name "container-name" -e MYSQL_ROOT_PASSWORD="mysqlroot-pswd" -e MYSQL_DATABASE=earthdb -e MYSQL_PASSWORD="mysql-pswd" mysql:latest '

  *feel free to change the ports (some people do 6033:3306) -This wont effect our api connection string
**I update the volume with the correct connection to the folder in the container for the above container setup, but the video will still show the /data folder.


#enter into container
` docker exec -it mysql-container bash `

#mysql commands:
mysql -uroot -p {optional: "dbname"} (-u root also works)

*checking the DB and tables
SHOW DATABASES;
USE "database-name";
SHOW TABLES;
DESCRIBE "table_name" or DESC "table_name"
or SHOW columns from "table_name";