Add ability to host MySQL DB instance in Docker

[velac01]

This would make it easier to develop and test the project, as well as deploy it to production.

The following steps would be required to add this functionality:

1. Create a Dockerfile for the MySQL DB instance.
2. Create a docker-compose.yaml file that defines the MySQL DB instance and its dependencies.
3. Update the README.md file to document the new functionality.

--

To host a MySQL instance in a Docker container, you can follow these steps:

1. Install Docker on your machine.
2. Pull the MySQL Docker image. You can do this by running the following command:

docker pull mysql:latest

3. Create a Dockerfile for your MySQL instance. This file will define the configuration of your MySQL container. Here is an example of a Dockerfile for a MySQL instance:

FROM mysql:latest

ENV MYSQL_ROOT_PASSWORD=my-secret-password

EXPOSE 3306

This Dockerfile tells Docker to use the latest version of the MySQL image, set the root password to my-secret-password, and expose port 3306, which is the default port for MySQL.

4. Build the Docker image from the Dockerfile. You can do this by running the following command:

docker build -t my-mysql .

This command will create a Docker image called my-mysql from the Dockerfile in the current directory.

5. Run the MySQL Docker container. You can do this by running the following command:

docker run -d -p 3306:3306 my-mysql

This command will run the MySQL Docker container in detached mode and map port 3306 on the host machine to port 3306 on the container.

6. Connect to the MySQL container. You can connect to the MySQL container using a MySQL client such as MySQLWorkbench or Sequel Pro. To do this, you will need to use the host machine's IP address and port 3306. For example, if your host machine's IP address is 192.168.1.100, you would connect to the MySQL container using the following command:

mysql -h 192.168.1.100 -p

Enter the root password when prompted.

Once you have connected to the MySQL container, you can create databases and tables, and insert data.