How to Set Up MySQL Database with Docker

[@DatabaseStar]

Want to easily remember the Docker commands for working with your database? Get my free Docker Cheat Sheet here: www.databasestar.com/docker-database-cheat-sheet/?

[@talios6824]

If every tutorial were as simple as this one, the world would be a better place. :)

[@DatabaseStar]

Thanks!

[@chriscastle374]

Seriously...just started a new job with absolutely no experience and they said, just go do this, figure it out..THIS, figured it out and i'm off on my next 'fetch' request two days earlier than they expected me to...

[@MichaelDude12345]

I was trying to learn how to set up a SQL database on my homelab as a beginner for like over a week, and I for the life of me couldn't figure out why it wasn't working. You really saved my butt with this video, thank you!

[@DatabaseStar]

Thanks, glad you found this useful!

[@pouriapmd6077]

two years later and still very helpful. thank you sir.

[@DatabaseStar]

Glad it helped!

[@brycenasay6051]

After spending HOURS trying to get this to work, this video is EXACTLY what I needed. Thank you so much!

[@DatabaseStar]

Glad to hear it helped you get it set up!

[@RogerHolden]

Great overview on how to do with Docker, but I'm not sure why anyone would want to do it this long-winded and complex way. On Linux you can install mySQL with a single line on the terminal and for Mac and Windows you can use MAMP or XAMPP which can be set up with a few simple clicks and have a GUI for easy management. I'm guessing Docker could allow different configurations?

[@DatabaseStar]

Thanks! Yeah MAMP and XAMPP are pretty easy to set up, but perhaps people don't need Apache or PHP that's included in those. Docker can be used for quick setups for development, and is often used during the deployment process, perhaps for using as a database on a test environment. I don't have a lot of experience with Docker but there are probably more advantages too.

[@kushagrakasliwal3930]

What a tutorial, detailed yet simple plus calming voice

[@DatabaseStar]

Thanks! I’m glad you like it!

[@ArisenO.O]

Mine is saying can’t connect to MySQL server with user root

[@DatabaseStar]

Oh, what error are you getting? Or is that the full error? Is the container running if you run “docker ps”?

[@heroman2937]

When i test the connection, i get an error message "Access denied for user 'root'@'localhost' (using password: YES)" . Any idea what might be causing that ? The container was made just fine and is running.

[@DatabaseStar]

That's strange. I assume the password you have entered is correct? If so, then there may be another MySQL instance running on your computer. If there isn't, then you could try changing the password, which is one of the steps I've written here: www.databasestar.com/access-denied-for-user-root-at-localhost/ If that doesn't work, then I'm not sure what could be the issue.

[@tarikb.2201]

Just two remarks. Why setting up a docker account to pull the image from docker hub? This is not necessary. Second one what about persistence? If you create tables etc, and fill them all the work is gone as soon as you stop the container. Why not adding a simple -v to the docker run command to set up a db file on the host?

[@DatabaseStar]

Good points! I set up a docker account as I was getting errors when pulling the images and my research found that I needed to set up an account. But this may not have been correct or may have changed. So it's good to see an account is not needed. Persistance is also a good point. Yes the contents will be lost if you reset the container. I do have another video on setting up a volume and how that works.

[@uditachakraborty5965]

Thank you, This has helped me to succesfully run the docker desktop and creta ea databse in windows.

[@DatabaseStar]

Glad it helped!

[@fatiheneskose4477]

the best and simplest tutorial about this topic, thanks

[@DatabaseStar]

Glad it was helpful!

[@skh551]

So couple of things I noticed, --name indicates the name of the container, not the image. So we can refer to the container by "some-mysql". "-p" is short for publish that represents mapping between the ports in local machine and containers, it does not mean just ports.

[@DatabaseStar]

Thanks for the information, that's good to know!

[@HaiTran-gx2fz]

my listen English is not good, so i don't understand at 8:14, i don't, where is my password. My SQL Workbench appear error. You can explain for me, where is my password at comand line "docker run" . Comman line "docker run", i write like you

[@DatabaseStar]

No problem! This is the password in the command shown at about 6:36. The part of the command that comes after MYSQL_ROOT_PASSWORD. In the video, this is my-secret-pw. So if you did the same as the video, you can enter my-secret-pw as the password.

[@HaiTran-gx2fz]

@@DatabaseStar thank you so much😘😘

[@yessicaapale3011]

3 years later and this help me too, thank you!

[@DatabaseStar]

I'm glad it's still helpful!

[@ericksantos12]

Hello! really nice tutorial thank you! I've one question, i've heard that docker containers are immutable and once they are killed all the data inside is gone forever, my question is if i kill mysql container all the data will be deleted? if yes there's a way to save to the host machine?

[@DatabaseStar]

Yes, the data in a database within Docker is not guaranteed to be kept if the image is stopped. This is why Docker is recommended for dev and test but not for prod (I believe). I do have a video on my channel about using binding and mounting a volume for Docker which can help.

[@ericksantos12]

@@DatabaseStar tysm

[@paladin9876]

@@DatabaseStar Docker is completely fine for Production environments. Why would you create a docker container for development and then not have that same environment in production? That's one of the main advantages of using Docker.

[@milon27]

i have created a database in digital ocean managed database service now when i use prisma to connect with it locally it works fine. but when i dovkerized the node js app then prisma saying not able to reach the database host p1001 error, db connection error. any idea how to fix it? i tried without prisma just mysql2 and it works in dockerized app.

[@DatabaseStar]

It sounds like there could be a connection issue with prisma in the docker container. But I don't know anything about prisma or putting NodeJS apps inside Docker.

[@milon27]

@@DatabaseStar fixed it by updating prisma to latest version

[@liamnguyen1748]

Very simple and concise tutorial. Keeps up the good work bro.

[@DatabaseStar]

Thanks!

[@manhkhang7732]

This tutorial is really helpful and instructive for a beginner like me. Much appreciated of your work!

[@DatabaseStar]

Glad it was helpful!

[@leonardocampan]

This is the best tutorial video I've ever seen :D thank you very much

[@DatabaseStar]

Oh thanks a lot!

[@Nam-k7h]

Hi Sir, I want to ask a question when I try to run this command: "docker run --name mysqlreview -e MYSQL_ROOT_PASSWORD=mypss -d -p 3312:3306 mysql:latest", If I confuse the container port (3306) with the host port (3312), and instead of 3312:3306 I type 3306:3312, besides not being able to run MySQL, I'm wondering if there are any risks involved? Thank you!

[@DatabaseStar]

Good question. I’m not sure actually. There might be some confusion if you have another service running on the same port, but that’s all I can think of.

[@kxk2328]

This was great - seriously thank you x 100! love your approach/style.

[@DatabaseStar]

Thanks! I’m glad you liked it.

[@slippinchillin]

This tutorial is very detailed, yet very simple! Thank you!

[@DatabaseStar]

Glad it was helpful!b

[@MelodySongsPlace]

Not able to connect to MySQL using docker credentials,how can I see database in my local MySQL's db?

[@DatabaseStar]

What issue are you having when connecting to MySQL?

[@bootifulghost8624]

Thanks very much for the video. Do you think it's possible and a smart idea to expose a DB through NGINX Proxy Manager? Is that even possible, so external applications can access the MySQL DB?

[@DatabaseStar]

Good question. I’m not familiar with NGINX Proxy Manager so can’t really advise on that 😕

[@bootifulghost8624]

@@DatabaseStar Thanks for the fast reply. How would I connect to the DB through the same network but from another computer?

[@MichaelDude12345]

@@bootifulghost8624 when you set up the database I'm sure you had to assign a port as well as find the ip address used by the host device (or if containerized then the Ip address of the container or vm). Go to mysql workbench (or whatever SQL associated software you want to use) on the computer on the same nextwork and type in the ip address followed by a colon and then the port you assigned under connections. That will let you access it from that computer. You can do that with any software that works with SQL and just put in that info, i have been using java so for me that means i provided that info to jdbc. It'll also ask for the username and the password you set up. Does that make sense? Hope that helped.

[@bootifulghost8624]

@@MichaelDude12345 Thanks for the reply, I already got it to work, even externally. Thanks nonetheless for your reply :)

[@NNNoName6263]

i was looking for this for quite some time the steps to connect to the db were really useful many thanks.

[@DatabaseStar]

You're welcome! Glad it helped.

[@tonycavanagh1929]

Do you need to have MySQL installed on your PC to get MySQL workbench working. I just want to use MySQL in docker.

[@DatabaseStar]

No, you don’t need to have it installed on your Pc. If you use this Docker process then MySQL is included in the Docker container.

[@tonycavanagh1929]

@@DatabaseStar Thanks will try and install MySQL workbench again.

[@swapnilkumar591]

latest: Pulling from library/mysql docker: no matching manifest for linux/arm64/v8 in the manifest list entries. See 'docker run --help'. getting this error

[@DatabaseStar]

Hmm I'm not sure what that error means unfortunately.

[@vensonestrope4534]

I did but I changed the port to 3307. How can I get the DB_Hostname cause I need to connect it to my laravel app. Hope you can help. Thank you.

[@DatabaseStar]

I think it should be localhost, that's what I use when I connect to the database when it runs in Docker.

[@zidrexandag9664]

what if you put data on the container and I stopped the container, if you run docker run again, will my data be retained? or can i just use docker start ?

[@DatabaseStar]

I think the data is kept if you stop and restart the container, but I'm not 100% sure on that. When I've used docker for my databases, the data is kept when I stop it. But I don't know when it is removed.

[@aaomms7986]

thx uuu . i've question if i've mysql server on my PC i still can use docker port 3306 same port with mymsql server?

[@DatabaseStar]

Yes, as long as they are not both running at the same time, it should be OK. I have the same situation: mysql installed locally as well as Docker.

[@aaomms7986]

@@DatabaseStar thxxxx

[@krishnasagar9492]

my mysql workbench is running 3307 port what should i do ,when i am entering 3306 port it is showing password denied error please help

[@DatabaseStar]

If your MySQL is on port 3307 you should be able to specify this port in Workbench and connect to it.

[@jessebatstone7853]

perfect thank you! was missing the port exposure tags.

[@DatabaseStar]

Glad it helped!

[@patrykK1028]

docker login doesn't ask me for credentials and instead says "Authenticating with existing credentials..." which doesn't do anything and it locks the command line so I can't write anything after that

[@DatabaseStar]

That's strange. Is there a way to log out from Docker on the command line and try the process again?

[@patrykK1028]

@@DatabaseStar I restarted my PC and then it asked me for credentials and worked

[@aniketpatil-d8e]

This tutorial is really helpful and instructive for a beginner like me. Much appreciated of your work! Could you please explain how setup cluster for same

[@DatabaseStar]

Thanks, glad it was helpful! I'm not sure how to set up a cluster unfortunately.

[@okorochavivian7153]

Mine is saying failed to connect to MySQL at 127.0.1:3306 with user root., is there any other way to correct the error?

[@DatabaseStar]

Hmm I would guess the password is incorrect or the Docker container is not running. I’m not sure what else it could be but I think it’s a common issue.

[@zuberpalekar]

@@DatabaseStar - This happens because the password set contains some special characters. For example, when I set the password as Pa$$w0rd it gives this error. I think the $ is perceived as some special character in the docker run command. I have had similar issue when running other containers when using the password with $ in it

[@srinathchintha9565]

@Database Star , Databa For me it's working with terminal but not working with Java code and DBeaver. getting Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. Connection refused (Connection refused) Please help.

[@DanKardell]

Great job! How do you connect via the commandline to the db?

[@DatabaseStar]

There is a command to do this that I've seen in some examples, but I haven't used it. I'll look at it and find out.

[@DanKardell]

@@DatabaseStar so I found that after creating the container that I could use "docker exec -it some-mysql bash" to get to a prompt and then use the "mysql" commands just like I had MySQL installed locally. Pretty cool! Thanks!

[@lalik777]

Thank , if i want container running on a specific host , for example 192.168.64.2 instead of localhost , how can we do it ?

[@DatabaseStar]

Hmm I’m not sure how to do that unfortunately!

[@westcoastwarriorsarchive7929]

for me the whole video was helpful, im currently trying to learn how to use corteza and was trying to figure out how to connect a database, turns out you connect to docker and it kind of just connects on its own somehow.

[@DatabaseStar]

Thanks, good to know the video was helpful and you got it working.

[@santrolli]

Thank you so much 😊 I appreciate your work! I wouldn’t be able to manage it on my own

[@DatabaseStar]

You're welcome, glad you like the video!

[@xinmwang3605]

@@DatabaseStar but there is no default table like emp .

[@aqkhana2002]

i was unable to connect with workbench , and i have to add user with I.P address to allow to access, why do i need i.p address ?

[@DatabaseStar]

What error message were you getting with MySQL Workbench? It seems strange you need to add the IP address.

[@christopherjspiteri]

When I run SELECT NOW() it shuts off the Mysql Workbench. I am using Docker on a Mac.

[@DatabaseStar]

That's odd. Does it crash for any other commands or queries you run?

[@vpms6054]

which version of workbench you have used... because my workbench version is 8.0.34 and its says that it may not work properly Good explanation by the way

[@DatabaseStar]

Oh what error are you getting, and where is it being shown? I'm using 8.0.21.

[@himanshupandey3451]

thanks. and how i connect this databas through powershell or command line of my local window machine?

[@DatabaseStar]

You're welcome! I think you can open a command line and run the "mysql" command. You'll need to specify the username and hostname. So something like this: mysql -u root -p -h localhost

[@WisdomIsAwesome]

I did the same process but I got this error when connecting with Mysql workbench: docker lost connection to mysql server at 'reading initial communication packet', system error: 0 Pls help!

[@DatabaseStar]

I haven't seen that one before, not sure what it could be unfortunately! The only thing I can think of is to try and wait 10-20 seconds for the container to start.

[@WisdomIsAwesome]

@@DatabaseStar I got the problem! I was using the "-p 3308:3308" ports mapping instead of "-p 3308:3306" ports mapping. So, it didn't get bound to to correct mysql port internally.

[@mr.pledplool272]

@@DatabaseStar I also had this problem. To clarify where this originates from: some MySQL server versions have the default host ip for the root user set to the localhost, meaning in case the of a dockerized MySQL server the Docker-internal localhost (try: "SELECT user, host FROM mysql.user;" from within the bash terminal of the container to see what I mean). Trying to access the MySQL Server from the normal host then yields the error that @Shashwat Khare pointed out. To circumvent simply change the root host ip to "%" (=any ip) ("UPDATE mysql.user SET host = '%' WHERE user = 'root';" also via the bash terminal of the container). Thanks for the vid btw. Great work!

[@december_randoms]

Let me ask how can we configure mysql docker container to be able to connect from host machine?

[@DatabaseStar]

Good question - I’m not sure actually!

[@zejiaann]

Hi, can i check how do other users connect to this database and how do i access this database and update it using RStudio?

[@DatabaseStar]

Oh I’ve never used RStudio before so I’m not sure how to connect with it. Hopefully others can respond and provide assistance.

[@КухняКухонька-р1ж]

Dont working!! I try to use -p 3307:3306, because there is local mysql server. And connection can not be created

[@DatabaseStar]

Oh, do you get an error message at all? What if you stop your local MySQL server?

[@law6906]

Does this mean if the container dies or is stopped then the data is lost?

[@DatabaseStar]

Yes, I believe so, which is why it's not recommended to use Docker in production or any database where you want to keep the data.

[@Schmiddiqt]

Really good tutorial. Helped a lot! Thank you

[@DatabaseStar]

Glad it was helpful!

[@rivertorres562]

Where is my image?, i need the dockerfile to upload to my github and i don't know where it is, please help

[@DatabaseStar]

I'm not sure where the image is stored actually. Hopefully the Docker documentation or a Google search could help.

[@TheInternetFan]

hi there, how would I modify this if I wanted to use VS Code instead of Workbench?

[@DatabaseStar]

The part that would change is connecting to the database. I have another video on vscode with sql, which involves installing an extension in vscode and connecting to the MySQL database

[@TheInternetFan]

@@DatabaseStar , will look it up then, thanks for your reply ;-)

[@SurendiranRaja]

How to create Dockerfile for mysql server hosting is possible?

[@DatabaseStar]

I’m not sure how to create a Docker file unfortunately

[@adjprojetscmc3867]

Amazing! I got it from the first time with you! Thank you so much!

[@DatabaseStar]

Glad it helped!

[@fatihachaibi2920]

hi thanks for this tutorial but when I test the connection it's failed why ??

[@DatabaseStar]

What error message are you getting?

[@vffncl0]

Any idea how to resource optimize this container?

[@DatabaseStar]

I’m not sure what that is unfortunately

[@sushmagowda9054]

Please help me fix this error. no matching manifest for linux/arm64/v8 in the manifest list entries.

[@DatabaseStar]

Hmm I've never seen that error before. What operating system are you running?

[@sushmashekar7796]

@@DatabaseStar On MACOS (m1 chip)

[@DatabaseStar]

Hm perhaps there's an issue with Docker on the new M1 chips? Has a Google search showed anything for this error?

[@Hifi58]

Thank you ! You make me love Docker !

[@DatabaseStar]

You’re welcome! Yeah it’s a pretty handy tool!

[@Supernyv]

Nice! Thank you very much @Database Star.

[@DatabaseStar]

You're welcome!

[@harryvideo]

I tried to do this and got the message localhost not found. I tried both the IP as well as the word localhost.

[@DatabaseStar]

Oh that’s interesting. Is the Docker container running? As in does it say running when you run “docker ps”?

[@kumarguru3044]

But people say a database as a container is a bad idea for prod environments. If so can you give me a good explanation?

[@DatabaseStar]

Yeah that's right, I've heard that too. I think it's because of the volatility of the data storage. There's a risk that a Docker container can be stopped and restarted, which may cause the data to be removed. From my basic knowledge, Docker is great for developing and testing databases but not advised for production.

[@ikahdesign]

Thank you so much for this tutorial. It's very important and useful.

[@DatabaseStar]

Thanks, I’m glad you like it!

[@gautamnaik2516]

Can we follow same steps in linux machine

[@DatabaseStar]

I think so, but I've never tried it.

[@radomircho]

Thank you very much for this video! It was very helpful! :)

[@DatabaseStar]

Glad it was helpful!

[@plnmbjj]

Direct to the point, thanks a lot!!

[@DatabaseStar]

Thanks, glad you liked it!

[@chrisslowedreverb]

This is amazing brother, thank you so much

[@DatabaseStar]

Glad it was helpful!

[@mosesodalo5074]

It worked, but when i want to connect with a php app its says mbind: Operation not permitted.

[@DatabaseStar]

Hmm I’m not sure what that issue could be unfortunately

[@giraldiego]

Thank you, it worked as you explained

[@DatabaseStar]

Glad it helped!

[@ad-vq8we]

I still cannot connect to my docker db

[@DatabaseStar]

Oh what error or issue are you having?

[@mdony722]

just like coldfusion TV , thank you

[@DatabaseStar]

Thanks!

[@margarita3873]

Your video helped a lot! Thank you!

[@DatabaseStar]

Glad to hear it!

[@Ra-fb6gx]

i got it successfully but i get this warning ; A connection to this database can be established but some MySQL Workbench features may not work properly since the database is not fully compatible with the supported versions of MySQL. MySQL Workbench is developed and tested for MySQL Server versions 5.6, 5.7 and 8.0. For MySQL Server older than 5.6, please use MySQL Workbench version 6.3.

[@DatabaseStar]

Interesting. Which version of MySQL are you using? The docker image should be a pretty new version.

[@m3xpl4y]

Thank you, this video helped me a lot, saved my day!

[@DatabaseStar]

Glad it helped!

[@ninjateknologi1523]

I got error while I try to open the connection using dbeaver

[@DatabaseStar]

What error are you getting?

[@ninjateknologi1523]

@@DatabaseStar I've solved my issue, I think there is a problem with the dbeaver. I try to use Mysql Workbench and it works. Thanks for your attention.

[@KAU50000]

Great tutorial, works at the first time.

[@DatabaseStar]

Great to hear!

[@一脸滑稽-k5v]

damn it I was following the tutorial, but I got problem and is stuck on it long time. I couldnt connect work bench to the thing

[@DatabaseStar]

Oh, what error message are you getting?

[@一脸滑稽-k5v]

@@DatabaseStar oh hi! Sorry seems like I just fixed it. Instead of 3306:3306, I did 3307:3306 and the workbench connect to 3307 and it worked

[@paschalokafor9043]

--name is the name of the container not image

[@DatabaseStar]

Thanks for the correction, good to know!

[@poorpanda9033]

Damn, Thanks a lot what a clean tutorial !

[@DatabaseStar]

Thanks!

[@hellocodeur]

thank you. it work for me without an error

[@DatabaseStar]

Happy to hear it!

[@peterkornos8749]

Thank you, nice, clean and helpful.

[@DatabaseStar]

Glad you like it!

[@ronmalachi9960]

Good job, nice and useful video !! Thanks

[@DatabaseStar]

Glad it was helpful!

[@Ra-fb6gx]

mysql has "Local Docker-Warning-not supported"

[@DatabaseStar]

Oh, which version are you using? I haven't seen that before.

[@KhuongNguyen-vm5kc]

holy shiet this channel is GOLD

[@DatabaseStar]

Thanks!

[@ihorslavinskyi9823]

the best tutorial ever

[@DatabaseStar]

Thanks!

[@haravindnaathatmalinggam4172]

If you ever face the error below when connecting to MySQL WorkBench, you may try out the solution :- Error --------- authentication plugin 'caching_sha2_password' cannot be loaded Solution ------------- 1. Enter the Docker for MySQL, with root login :- $ docker exec -ti -uroot -p 2. Then run the command :- ALTER USER 'username' IDENTIFIED WITH mysql_native_password BY 'password'; *It can be for the username = root and root password

[@DatabaseStar]

Thanks for sharing!

[@jorgeduran6400]

good work! all in this video works fine!

[@DatabaseStar]

Good to hear!

[@oscarmejia8306]

Got error: Public Key Retrieval is not allowed

[@DatabaseStar]

Was this when you ran one of the docker commands on the terminal, or some other time?

[@the_pachu4953]

thanks so much! keeep going making greant content!

[@DatabaseStar]

Thanks!

[@NitrosS]

it doesn't work, I can't connect

[@DatabaseStar]

What issue are you having? Is there an error message?

[@nicetomeetugaming7024]

Amazing video sir!

[@DatabaseStar]

Thanks, glad you like it!

[@antonleshchuk5908]

Very succinct and clear. Thx

[@DatabaseStar]

Thanks!

[@joao71gaming]

Awesome ! Thank you so much !

[@DatabaseStar]

No problem!

[@justinkao8049]

I turn the volume to the max, still can't hear you clearly....

[@DatabaseStar]

Thanks for the feedback! I’m improving my audio with each video and some of my earlier ones like this were a little quieter.

[@ahmedabuqamar1517]

Thank you, it's nice video Keep on

[@DatabaseStar]

Thanks!

[@Devman483]

thank you easy and simple

[@DatabaseStar]

You’re welcome!

[@vikasts1063]

great tutorial thanks

[@DatabaseStar]

You're welcome!

[@GabrielFerreira-sx8yc]

thank you helped me 🤙

[@DatabaseStar]

No problem!

[@petergnadig4865]

thanks for this tutorial

[@DatabaseStar]

You're welcome!

[@blackbarry45]

. please I am looking for docker swarm secrets

[@DatabaseStar]

What are docker swarm secrets?

[@alijenab9131]

thanks it was useful.

[@DatabaseStar]

Glad it was helpful!