In this article

Single Command Database Setup

Kamran Ahmed Kamran Ahmed

When you are working on a backend application, you are likely to need a database. You can either install it on your machine or use a Docker container. I prefer to use Docker containers because it is easier to setup and doesn’t pollute my machine with unnecessary dependencies.

This short guide will show you how to spin up a MySQL, PostgreSQL, or MongoDB instance on your local machine using docker. Feel free to submit a PR adding more databases.

PostgreSQL

You can run the following command to run PostgreSQL in a Docker container:

docker run \
  --name pg \
  --detach \
  --publish 5432:5432 \
  --env POSTGRES_PASSWORD=admin \
  postgres

Now you can connect and run commands against the instance using the following:

docker exec -it pg \
  psql -U postgres

MySQL

You can run the following command to run MySQL in a Docker container:

docker run \
  --name ms \
  --publish 3306:3306 \
  --detach \
  --env MYSQL_ROOT_PASSWORD=admin \
  mysql

Now, you can use the following to run commands against the MySQL instance:

docker exec -it ms \
  mysql -u root -padmin

MongoDB

You can run the following command to run MongoDB in a Docker container:

docker run \
  --name mdb \
  --publish 27017:27017 \
  --detach \
  mongo

Now, you can use the following to run commands against the MongoDB instance:

docker exec -it mdb \
  mongo

Feel free to submit a pull request by adding additional databases to this guide.

Actively Maintained

We are always improving our content, adding new resources and adding features to enhance your learning experience.

Join the Community

roadmap.sh is the 7th most starred project on GitHub and is visited by hundreds of thousands of developers every month.

Rank 7th  out of 28M!

296K

GitHub Stars

Star us on GitHub
Help us reach #1

+90k every month

+1M

Registered Users

Register yourself
Commit to your growth

+1.5k every month

28K

Discord Members

Join on Discord
Join the community

Roadmaps Best Practices Guides Videos FAQs YouTube

roadmap.sh by @kamrify

Community created roadmaps, best practices, projects, articles, resources and journeys to help you choose your path and grow in your career.

© roadmap.sh · Terms · Privacy · Advertise ·

ThewNewStack

The top DevOps resource for Kubernetes, cloud-native computing, and large-scale development and deployment.