...
| parameter | value |
|---|---|
| <password> | memorable password, I keep it simple when developing |
| <path to share with container> | //Cc/Users/Selvyn/demo/vm_share/mysql //Cc/Users/Selvyn/ must be the path to your account's home directory if you are using windows, or your home directory on Linux/Unix The demo/vm_share/mysql can be any directory under your home folder |
| <image id> | Should be the image id for mysql if you run docker images |
| Info | ||
|---|---|---|
| ||
//c/ the drive letter must be lower case |
Using the above table I use the following command
| Code Block | ||||
|---|---|---|---|---|
| ||||
docker run -p 3306:3306 --name mysql-populated -e MYSQL_ROOT_PASSWORD=ppp -d -v //Cc/Users/Selvyn/demo/vm_share/mysql:/root mysql-db-unpopulated:latest |
...
Within the demo/vm_share/mysql folder I have the following files (docker exec by default logs in as root)
| file | purpose |
|---|---|
| .bashrc | When you mount an external volume to /root folder of the container the .bashrc will be removed if none is specified in the host environment |
| .profile | When you mount an external volume to /root folder of the container the .profile will be removed if none is specified in the host environment |
| .bash_history | When you mount an external volume to /root folder of the container the .bash_history will be removed if none is specified in the host environment |
| init-populate-mysql-db.sh | Simply invokes mysql --password=<pwd> < <a script file> to execute a mysql script |
| create-db-teams-and-lectures-for-2017.sql | Script to create users on the mysql account, must be done before schemas are created |
| db_grad_cs_1917.sql | Script to create a schema and populate |
Don't try to access the DB either through docker exec or MySQL workbench for about 20-30 seconds. The docker run (don't confuse docker run with docker start) command will take about 20-30 seconds to fully initialise the container and completely run the scripts above.
...