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



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 :
Youtube:

🌸 Follow me On Social Media
Facebook :

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

🌸 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

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

32 thoughts on “How To Create And Test MySQL Database Server in Docker On Ubuntu Linux

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

  2. 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.

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

  4. 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

  5. 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

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

    Thanks! Thanks!

  7. 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.

  8. 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 ?

  9. 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!

  10. 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

  11. 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 🙂

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

  13. Step 7/8 : ADD database.sql /docker-entrypoint-initdb.d

    ADD failed: stat /var/lib/docker/tmp/docker-builder235937173/database.sql: no such file or directory

Leave a Reply

Your email address will not be published. Required fields are marked *