The process of setting up a Mysql container with Docker Desktop and connecting from the host machine

Claudio Ctin2 months ago2 mins

Docker Desktop version is 4.32.0

Get Mysql Image

There is a search bar at the header.
Input mysql and you will see a list containing mysql.
Click on it.

You will see the Pull button and click it.
If you wanna pull the image via the terminal, use the following command:

docker pull {image_name}

Set Up Environmental Variables

After the image is downloaded, go to the images page from the drawer and you will see the MySQL image listed.
Click the run buttn.

In the Optional settings, input the values as below and click the Run button

The command is as follows:

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

Connect To The Mysql Container From The Host Machine

You might think that you can connect with the following command:

mysql -u root -p

But actually you can’t.
The error message will be:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)

I asked ChatGPT about the reason for the error and the answer is you need to add the host IP as below.

mysql -u root -p -h 127.0.0.1

And now you can connect to it.
Thank You!!

Please follow and like us:

Stiri similare

How to add RAG & LLM capability to Amazon Lex using QnA Intent and Amazon Bedrock models

Claudio Ctin2 hours ago1 hour ago

Conversational AI has rapidly evolved, offering more dynamic and personalized interactions between users and applications. Amazon Lex, a powerful service for building conversational interfaces, already provides robust capabilities for creating chatbots. However, as user demands grow, the need for more sophisticated and contextually aware responses becomes essential. This is where Retrieval-Augmented Generation (RAG) comes into…

VSCode Extension for finding Vulnerabilities and Outdated Dependencies.

Claudio Ctin2 hours ago1 hour ago

Hi All, I have just published a VSCode extension for auditing NPM dependencies for Vulnerabilities and Outdated Packages. Extension provides inline actions, which will allow us to fix the issues from the report page itself (Avoiding manual ‘npm install/update’). Generated report can be downloaded & shared, if required. Nothing can’t be made perfect in a…

The Power of Reflection: Recognizing Your Efforts. Don’t Let Expectations Steal Your Joy.

Claudio Ctin3 hours ago1 hour ago

Why are we so easily blinded by our expectations and dreams that we fail to appreciate our efforts, progress, and wins? Why do we sometimes forget to celebrate the journey in our pursuit of the destination? I woke up this morning feeling so down. I wouldn’t call it depression, but I would say frustration over…

Explorando org-babel en emacs

Claudio Ctin3 hours ago1 hour ago

Soy usuario de GNU/Emacs desde el año 2005. A pesar de tanto tiempo, no me considero un experto. No me he querido meter de lleno con ELisp, por ejemplo, así que las configuraciones que hago a emacs, las hago basándome en consejos de internet. Y, de un tiempo para acá, empecé a usar doom emacs,…

LEARNING HOW TO: useEFFECT and useSTATE, A REACT APP.

Claudio Ctin3 hours ago1 hour ago

I have been working on a web app called “Heat” , the sole purpose of the app is to help me learn and apply JavaScript and improve my CSS, lots of backend also. The plan was to create a visually appealing web app with a couple of fun features. What I have learned in the…

Install IBM Db2 Community Edition on Amazon EC2 (Ubuntu)

Claudio Ctin3 hours ago1 hour ago

In this tutorial, we’ll guide you through the step-by-step process of installing IBM Db2 Community Edition on an Amazon EC2 Ubuntu instance. We’ll cover everything from setting up the EC2 instance to configuring Db2 and creating your first database. IBM Db2 Community Edition is a cloud-native database designed to deliver low-latency transactions and high resilience…

What you working on?

Claudio Ctin3 hours ago1 hour ago

Are you working on a saas tool? the next todo app? let’s hear it below Please follow and like us:

OCaml Dockerfile build from scratch

Claudio Ctin3 hours ago1 hour ago

I’m trying to package Ocaml programs for future container deployments. Upon looking at docker hub, there is no official Ocaml base images other than ocaml/opam, which doesn’t really suit my use case. I created two versions of ocaml base images, with the goal of optimized image sizes. One based on Ubuntu and one base on…

Day 6. Work on Sunday

Claudio Ctin3 hours ago1 hour ago

Working on Sunday is the most challenging task. I cannot spend much time because you have responsibility to my family. From my experience, weekend is important time for recharging for next week. I try to avoid working much on the weekend, otherwise, work becomes less enjoyable. I find it more enjoyable on work days. What…

Building a RESTful API with Node.js: A Step-by-Step Guide – Part Two – Node Modules

Claudio Ctin3 hours ago1 hour ago

Overview of Node.js Modules Node.js modules are crucial for building scalable and maintainable applications. They help organize code and extend functionality through encapsulation, scalability, and ease of maintenance. Here’s a quick guide on using different types of Node.js modules: Creating a Custom Module Example: Arithmetic Operations Create arithmetic.js: // Define basic arithmetic functions const add…

JavaScript Array Methods: A Comprehensive Guide

Claudio Ctin3 hours ago1 hour ago

Arrays are one of the most fundamental data structures in JavaScript. With an array, you can store multiple values in a single variable. JavaScript provides numerous built-in methods to manipulate arrays, making them incredibly versatile. In this post, we’ll explore all the built-in array methods and how to use them effectively in your JavaScript projects….