MENU

Fun & Interesting

How to Set Up MySQL Database with Docker

Database Star 215,588 4 years ago
Video Not Working? Fix It Now

? Get your FREE cheat sheet of Docker commands: https://databasestar.mykajabi.com/lpkj-docker-cheat-sheet/?video=kphq2TsVRIs ? Master SQL Fundamentals: https://databasestar.mykajabi.com/sql-simplified/?video=kphq2TsVRIs Docker is a product that allows developers to create containers, which are self-contained areas on their computer for running applications. They can be used for databases, which is great if you can't install it normally (e.g. you use a Mac). This video shows you how to set up a MySQL database on Docker. It uses an existing MySQL image on the Docker Hub website. You can use many different versions of MySQL, not just the latest version. You'll learn how to download and install Docker, find the right MySQL image, download the image, run it, and connect to it in MySQL Workbench. You can use any other IDE that works with MySQL if you prefer. The connection details for this image mentioned in the video are below. Host: localhost (or 127.0.0.1) Port: 3306 Username: root Password: whatever you specify in the "docker run" command Timestamps: 00:00 In this video 00:05 High-level steps 00:28 Download Docker 01:22 Run Docker 02:07 Create Docker Hub account 02:41 Search for MySQL image on Docker Hub 03:12 Understand the docker run command 04:25 Adjust docker run command 05:28 Open Terminal and login to Docker 06:18 Download image using Docker Run 07:04 Check status using docker ps 07:33 Connect using MySQL Workbench 07:58 Enter connection details 08:54 Run simple query

Comment