Pull the image docker pull mysql View the completed image docker images Create and start a MySQL container through the image docker run --name mysql_dev -e MYSQL_ROOT_PASSWORD=123456 -p 3333:3306 -d mysql
View all installed containers docker ps -a View the started container docker ps Stop/start services in the container docker stop mysql_dev docker start mysql_dev Entering the container docker exec -it mysql_dev bash View the IP address of the service in the container docker exec -it mysql_dev cat /etc/hosts The new version of MySQL reports an error when authorizing a user: near 'IDENTIFIED BY 'password' with grant option' at line 1 1 Question: When using the grant permission list on the database to 'user name'@' access host' identified by 'password'; the error "......near 'identified by 'password'' at line 1" will appear 2 reasons: Because the new version of MySQL has separated the way to create accounts and grant permissions 3 Solutions: Create an account: create user 'user name'@'access host' identified by 'password'; 4 Specific operations: # Add user CREATE USER 'mysql_dev' IDENTIFIED BY '123456'; # Grant permissions GRANT ALL PRIVILEGES ON *.* TO 'mysql_dev'@'%'; # Modify encryption rules ALTER USER 'mysql_dev'@'%' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; # Update the user's password ALTER USER 'mysql_dev'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; # Update configuration information FLUSH PRIVILEGES; The above is the details of the tutorial on how to install MySQL with Docker and realize remote connection. For more information about installing MySQL with Docker and realizing remote connection, please pay attention to other related articles on 123WORDPRESS.COM! You may also be interested in:
|
<<: Causes and solutions for MySQL deadlock
>>: JavaScript to achieve text expansion and collapse effect
Docker is being used in more and more scenarios. ...
Table of contents What to do when registering an ...
Table of contents Preface Target first step: Step...
Modern browsers no longer allow JavaScript to be ...
Table of contents 1. Custom routing 2. Tab naviga...
1. CSS background tag 1. Set the background color...
Does color influence website visitors? A few year...
This article shares with you how to use the Vue s...
1. Create a MySQL database 1. Create database syn...
Last night I wrote an essay about the browser ren...
Table of contents 1. Three modes of binlog 1.Stat...
You might be wondering why you should use the pat...
Create a container [root@server1 ~]# docker run -...
HTML web page list tag learning tutorial. In HTML ...
I used the Mysql FIND_IN_SET function in a projec...