How to start mysql by docker
The process of starting MySQL in Docker consists of the following steps: Pull the MySQL image to create and start the container, set the root user password, and map the port to verify the connection Create the database and the user grants all permissions to the database
How to start MySQL in Docker
Starting MySQL in Docker is a relatively simple process that provides a convenient way to run MySQL in an isolated and portable environment.
step:
-
Pull MySQL image:
<code>docker pull mysql</code>
Copy after login -
Create and start the container:
<code>docker run -d --name mysql -e MYSQL_ROOT_PASSWORD=your_password -p 3306:3306 mysql</code>
Copy after loginin:
-
-dflag runs container in daemon mode -
--name mysqlspecifies a name for the container -
-e MYSQL_ROOT_PASSWORD=your_passwordSet the password of the MySQL root user -
-p 3306:3306Map port 3306 in the container to port 3306 of the host
-
-
Verify the connection:
After waiting for the container to start, you can verify the connection using the following command:<code>docker exec -it mysql mysql -u root -p</code>
Copy after login -
Create databases and users:
After connecting to MySQL, you can create a database and user using the following command:<code>CREATE DATABASE your_database; CREATE USER 'your_username'@'%' IDENTIFIED BY 'your_password';</code>
Copy after login -
Grant permissions:
Finally, grant new users all permissions to the new database:<code>GRANT ALL PRIVILEGES ON your_database.* TO 'your_username'@'%';</code>
Copy after login
Now, you have successfully started and configured MySQL in Docker.
The above is the detailed content of How to start mysql by docker. For more information, please follow other related articles on the PHP Chinese website!
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1381
52
How to read the docker version
Apr 15, 2025 am 11:51 AM
To get the Docker version, you can perform the following steps: Run the Docker command "docker --version" to view the client and server versions. For Mac or Windows, you can also view version information through the Version tab of the Docker Desktop GUI or the About Docker Desktop menu.
How to create a mirror in docker
Apr 15, 2025 am 11:27 AM
Steps to create a Docker image: Write a Dockerfile that contains the build instructions. Build the image in the terminal, using the docker build command. Tag the image and assign names and tags using the docker tag command.
How to change the docker image source in China
Apr 15, 2025 am 11:30 AM
You can switch to the domestic mirror source. The steps are as follows: 1. Edit the configuration file /etc/docker/daemon.json and add the mirror source address; 2. After saving and exiting, restart the Docker service sudo systemctl restart docker to improve the image download speed and stability.
How to check the name of the docker container
Apr 15, 2025 pm 12:21 PM
You can query the Docker container name by following the steps: List all containers (docker ps). Filter the container list (using the grep command). Gets the container name (located in the "NAMES" column).
How to view logs from docker
Apr 15, 2025 pm 12:24 PM
The methods to view Docker logs include: using the docker logs command, for example: docker logs CONTAINER_NAME Use the docker exec command to run /bin/sh and view the log file, for example: docker exec -it CONTAINER_NAME /bin/sh ; cat /var/log/CONTAINER_NAME.log Use the docker-compose logs command of Docker Compose, for example: docker-compose -f docker-com
How to use docker desktop
Apr 15, 2025 am 11:45 AM
How to use Docker Desktop? Docker Desktop is a tool for running Docker containers on local machines. The steps to use include: 1. Install Docker Desktop; 2. Start Docker Desktop; 3. Create Docker image (using Dockerfile); 4. Build Docker image (using docker build); 5. Run Docker container (using docker run).
How to save docker image
Apr 15, 2025 am 11:54 AM
To save the image in Docker, you can use the docker commit command to create a new image, containing the current state of the specified container, syntax: docker commit [Options] Container ID Image name. To save the image to the repository, you can use the docker push command, syntax: docker push image name [: tag]. To import saved images, you can use the docker pull command, syntax: docker pull image name [: tag].
How to update the image of docker
Apr 15, 2025 pm 12:03 PM
The steps to update a Docker image are as follows: Pull the latest image tag New image Delete the old image for a specific tag (optional) Restart the container (if needed)
