MySQL Docker Tutorial | MySQL Docker Setup | How To Run MySQL In Docker Container

#mysql, #docker, #database Hello Friends, Welcome back to my channel.

This video is a on mysql tutorial and how to run mysql in docker. You can easily spin up my sql docker containers and start working on the databases. Check out the whole commands listed below.

docker container run -d --name mysqldb -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password mysql:latest

docker exec -it mysqldb bash

mysql -u root -ppassword

show databases;

create database company;

drop database company;

use company;

create table team ( id int not null, name text, primary key (id) );

show tables;

insert into team (id , name) values (1, 'Thetips4you');

insert into team (id , name) values (2, 'King');

insert into team (id , name) values (3, 'Queen');

select * from team;

#mysql, #mysqlinstallation, #mysqldatabasetutorial

=================================================
Follow me @:
======================================================

Note: Each word by Word or sentences used in this video is self written and converted to Audio to give explanation on the steps in each tutorial . These are not automated or third party content or scrapped from any website.

Music credit: "Royalty Free Music from Bensound"

[TheDrewCrawford]

This video was extremely helpful. A few things that tripped me up (incase anyone else has the same issues). I had been running mysql 5.7 locally but wanted to run 8.0 at the same time. Docker seemed like a great solution. When following the video, my docker run command failed telling me that port 3306 was not available. I had forgotten to stop my local mysql instance that was running on windows. After it was stopped everything worked just find. Also, I couldn't get connected from the mysql workbench at first. I was getting an authorization plugin failed to load error. I had workbench 6 installed and didn't realize that it didn't work for mysql 8.0. I upgraded to workbench 8 and everything worked as expected.
Lastly, I really appreciate that you used a text-to-speech program for your video. I've seen several others that only show the coding but I find that much more confusion without the explanation. Thank you for sharing your knowledge.

[bekjanomirzak]

Thank you, keep going your videous are really helpful, I keep referencing back this video again and again whenever I forget how to set up my mysql.

[Сова]

thank you, good man from the internets for saving me time

[TheNobodyPlace]

Such a helpful video ! A big thanks <3

[etiennemarques]

finally a usefull help has been found! thank you so much!

[СергейМагаз-ль]

Great video! Thank you, you save my time!

[JenniferStewart]

So do you need to run Docker separately in your React App as well? Thats where I get confused. I see some tutorials with Docker files in the React App, and then some like this one. This was super helpful though, don't get me wrong, it was so helpful!

[navedkhan]

to know the ip use the command :- docker port mysqldb

[minhucreview]

Can u explain me hostname in mysql workbench, i can't connect db in mysql workbech.

[bhaskar.bantupalli]

How to get the ip addreess of mysqldb container to use in mysql workbench

[vffncl]

Any idea how to resource optimize this container?

[parkourllt]

Hey, great video! Need some help: how do you get the hostname IP adress? Thanks

[ShovaKuikel]

Can you please help me, I couldn't connect my DB "cannot connect to server"

[programming]

excuse me but when I tried "mysql -u root -ppassword"
I get the next error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

Why is this?

[jamiecoates]

Hi tryed running first command to install container it failed. I think you are in Docker root, how do i get there? error message says i need docker login

[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!