官方文档: https://dev.mysql.com/doc/ https://github.com/PyMySQL/PyMySQL
https://pymysql.readthedocs.io/en/latest/ https://docs.mongodb.com/ecosystem/drivers/pymongo/ https://github.com/mongodb/mongo-python-driver https://www.postgresql.org/docs/11/external-interfaces.html https://github.com/psycopg/psycopg2 官方镜像: docker hub
| mysql | mongo | postgres |
server启动 |
docker run --detach --name mysql \ -e MYSQL_ROOT_PASSWORD=qwe123 \ -p 3306:3306 \ -v /container_mount/mysql:/var/lib/mysql \ mysql
|
docker run --detach --name mongo \ -e MONGO_INITDB_ROOT_USERNAME=mytest \ -e MONGO_INITDB_ROOT_PASSWORD=qwe123 \ -p 27017:27017 \ -v /container_mount/mongo:/data/db \ mongo
|
docker run --detach --name postgres \ -p 5432:5432 \ -e POSTGRES_PASSWORD=qwe123 \ -e POSTGRES_USER=mytest \ -v /container_mount/postgres:/var/lib/postgresql/data \ postgres
|
client连接 |
docker run -it --rm mysql \ mysql -h 10.63.132.219 -P 3306 -u root -p
|
docker run -it --rm mongo \ mongo 10.63.132.219:27017 \ -u mytest -p qwe123 --authenticationDatabase admin
|
docker run -it --rm postgres \ psql -h 10.63.132.219 -p 5432 -U mytest -W
|
cat >> clear_db.sh << EOF #!/bin/bash rm -rf /container_mount/mysql /container_mount/mongo /container_mount/postgres docker stop mysql && docker rm mysql docker stop mongo && docker rm mongo docker stop postgres && docker rm postgres EOF chmod 777 clear_db.sh