Local Database setup In just 5 Mins (docker+mysql+workbench)

[AutomationCoreDev]

Thank a bunch pal. Remember you helped a lot of people.

[ronaldo-mendes]

You helped me a lot! Thanks for the explanation!

[TajZver]

Thank you ezy pizy explanation everything works smoothly!

[valdineidiney]

dude u r just amazing, work perfectly.

[JuTa]

Thank you very much! I was digging my mistakes as I couldn't find info how to use another port for Docker! Hugs))

[linhchi]

thank you so much. You help me a lot!!

[ravirajvijayan]

Bro Thank you soo much it help me to connect my database :)

[christiewolters]

when I run docker exec -it [connection name] /bin/bash it says OCI runtime exec failed: exec failed: unable to start container process: [address] no such file or directory: unknown

[andrewvalevskiy]

Thank you very much, works fine! English isn't my native language, so, tell me, please, why did you do update query for updating host from localhost to '%'?Thanks

[CPEDGG]

What macos version are you using during this presentation? I am using the exact same commands you have showed however I am getting "ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)" when using "mysql -uroot -p -P3307 -h127.0.0.1"
Thank you.

[nataliapalweski]

i setup MYSQL_ROOT_PASSWORD: 'password' in yml file but by doing this when i enter password in cli it is saying "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)"

[rahulprajapati]

thanks man!
You help me.
i was getting this error on macbook pro m1 chip while running docker mysql
docker: no matching manifest for linux/arm64/v8 in the manifest list entries.

Steps 1 : docker run --platform linux/x86_64 -p 3307:3306 --name my-mysql -e MYSQL_ROOT_PASSWORD=root -d mysql
Step 2: docker ps -a ( just for listing images)
Step 3: docker exec -it my-mysql /bin/bash
Step 4: mysql -u root -p (Enter password)
Step 5: update mysql.user SET host="%" where user="root";
Step 6: flush privileges;
Step 7: exit from mysql and container

now your mysql container is ready to use.

[usmanqureshi]

Appreciate I have wasted a whole day on Stack

[joseivanperezugalde]

bash-4.4# mysql -u root -p -A
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[inti]

dislike, the duration of video was 6 Mins, not 5 Mins.