How To Create And Test MySQL Database Server in Docker On Ubuntu Linux

How To Create And Test MySQL Database Server in Docker On Ubuntu Linux

MySQL is a widely used, open-source relational database management system (RDBMS).
In this video I'm going to show you how Docker works, what all the fuss is about, and how Docker can help with a basic MySQL database server.

This is a great Docker use case. We might not want to run our production database in Docker, but we can spin up a clean MySQL database in no time as a Docker container for development and testing.

🌸 Support channel & make donation :

🌸 Subscribe for more videos :

🌸 Follow me On Social Media

***********************************************************************

🌸 How To Check Bad Blocks Or Bad Sectors On a Hard Disk In Linux

🌸 Linux How To Partition a Hard Drive Using the Parted Command

🌸 Checking or Repairing a File System using fsck in Linux

🌸 How To Monitor the Health of Your Hard Drive in Linux using SMART

🌸 Linux iotop: Monitor your disk Input/Output

🌸 How To use the “du” (Disk Usage) Command in Linux

🌸 How To View Manipulate System Logs In Linux Using Journalctl Command

🌸 How To Sync And Backup Files In Linux Using Rsync Command

🌸 Linux cURL Command Tips and Tricks

🌸 Linux tail and multitail commands

🌸 Linux How To view Log Files

🌸 How To use the History Command On Linux

🌸 Tips and Tricks How To manipulate Text Files on Linux

🌸 How to Archive, Compress and Extract Files Using the tar Command on Linux

🌸 Linux - How to split larger files into smaller parts

🌸 Linux commands : Top

***********************************************************************

[Muhammed_Azif]

Wow. Your efforts are highly commendable. 🎉🎉

[rakeshpatil]

Thank You So Much for this video @Liv4IT. As a beginner I was not aware of creating images in docker, run docker applications, etc. but this video clearly and nicely explained me the concept and procedure to do that. It was an awesome video, and please keep this great work ahead.

[pierrefrancisroy]

Thank you so much, this was exactly what I needed. I was never able to figure out how to use the predefined variables and un my script. Now this is doing exactly what MySQL is supposed to do in a container.

[parthapratimbaral]

Thank you. This is pretty straight forward and what I am searching for.

[rvjaws]

Thank You SO much Dear Sir.. Love you from India

[seriouslee]

Brilliant tutorial. I'd like it a thousand times if I could. Thank you!

[oualid_o]

it's work thank you so much, Brilliant tutorial.

[AOBComputer]

Thank you so much!!! This was very instructive and I was able to do the whole thing.

Thanks! Thanks!

[xenonsan]

Thinking about doing a workshop for a club I am apart of covering SQL since people asked to cover it. This is great and a lot easier then installing the server physically on your PC, taking up so much space. I just wish everyone at my Uni didn't use Windows as it's extremely difficult to get Docker on Windows. Thank you!

[snowbydave]

I have watched your entire tutorial. It is working, however it will only create database, but will not create table. I have created my own table and insert record. That SQL file work perfect with phpmyadmin

[ThePacmanAddict]

Thank you for this video you saved my butt lmao

[current]

Thanks for your great tutorial, but for what you are forwarding ports into outer world if you use exec?

[razvan.cirlugea]

i love this tutorial and the background music relaxes me a lot. Can someone tell me how can i find that music?

[nnbrs]

Great video! but how can remote MySQL container in my computer client such as using MySQL workbench?

[gregkan]

hello ! great video and would suggest it to people starting with docker !! But i have to ask :

Suppose i did everything same as you at an Ubuntu machine running as a server. Now i want to access this database "users" in the server from multiple REMOTE pc's.
The IP i should use is the server's (host's) IP or something else?

In windows we used an IP 192.168.99.100 which is the Virtual Box default IP. What is the case in ubuntu ?

[leungfelix]

Your terminal is beautiful and seems can auto fill commands. Can you please help to share how to setup such terminal.

[akshaykasar]

Where i get find setup.sql file sir?..n i have already sql server which is running on port 3306 so can i run this sql container on port 3310

[AIclould]

When is the location of mysql my.cnf? and how to define datadir in separate directory /mount point

[kanwarjeetkhalsa]

for anyone stuck on the .Dockerfile not working. This worked for me: FROM mysql:latest
ENV MYSQL_ROOT_PASSWORD 123
ENV MYSQL_DATABASE users
ENV MYSQL_USER $user
ENV MYSQL_PASSWORD 1234
COPY script.sql /docker-entrypoint-initdb.d/
EXPOSE 3306

[patrikmaryska]

Hello!,
how Can I connect to that container from my server? I have node-js and when I try to connect to mysql, It is for me impossible to connect... I found out IP of the container using: docker inspect db2 | grep IPAddress
Thank you :)