Description: The following snippet help creating simple mysql docker container for dev and testing purpose.
Start with default
docker run \
-p 3306:3306 \
-v /data/mysql/mysql:/var/lib/mysql \
--name mysql \
-e MYSQL_ROOT_PASSWORD=my-secret-pw \
--rm \
-d \
mysql:5.7.27
Start with case insensitive
docker run \
-p 3306:3306 \
-v /data/mysql/mysql:/var/lib/mysql \
--name mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw \
--rm \
-d \
mysql:5.7.27 \
--lower_case_table_names=1