lec00q/mysql repository overview

⁠docker-mysql

A docker image for running a mysql server instance that also supports python and SQLAlchemy. This is one of the docker images used for development at Trya⁠.

It is based on the mysql image⁠ provided by CenturyLink.

⁠Usage

Run a container exposing port 3306 to the host and changing default root password:

 $ docker run -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=mysecretpwd lec00q/mysql

The default workdir is /tmp/db.

⁠Setup a new database schema

You can use python scripts to setup a new schema.

For example, suppose that you have a python script named dbclasses.py which exploits SQLAlchemy. That script is in a local directory named /home/lec00q/database. Let's mount that directory as a volume:

$ docker run --name mysql -p 3306:3306 -v /home/lec00q/database:/tmp/db -e MYSQL_DATABASE=mydb lec00q/mysql

Note that we have also created a new database called mydb. While the container is running, you may run the script using docker exec:

$ docker exec mysql python -c "import dbclasses; db_classes.initialize('mydb')"

⁠Environment variables

• MYSQL_ROOT_PASSWORD: The password for the root user. Defaults to a blank password
• MYSQL_DATABASE: A database to automatically create. If not provided, does not create a database.
• MYSQL_USER: A user to create that has access to the database specified by MYSQL_DATABASE.
• MYSQL_PASSWORD: The password for MYSQL_USER. Defaults to a blank password.