Detailed explanation of using Docker to build externally accessible MySQL

Install MySQL 8.0

docker run -p 63306:3306 -e MYSQL_ROOT_PASSWORD=zhaooleemysql --name zhaooleemysqldb -d mysql:8.0

• p 53306:3306 maps port 3306 of the docker container to port 63306 of the host machine
• -e MYSQL_ROOT_PASSWORD=zhaooleemysql The root user login password is zhaooleemysql
• --name zhaooleemysqldb The name of the new container is zhaooleemysqldb
• mysql:8.0 The mysql database version used is 8.0

Entering the container

docker exec -it zhaooleemysqldb bash 

Login to database

mysql -uroot -p
zhaooleemysql

Create a new user (8.0 is more strict, it is troublesome to log in remotely with the root user, we choose to create a new user)

create user 'zhaoolee' identified with mysql_native_password by 'eelooahzpw';

zhaoolee new user name is zhaoolee. The mysql_native_password encryption method is mysql_native_password eelooahzpw new user's password is eelooahzpw

Add permissions for the new user zhaoolee

grant all privileges on *.* to 'zhaoolee';

Refresh permissions

flush privileges; 

Create a new database

create database v2fy charset=utf8;

The name of the new database is v2fy

Exit Database

exit

Exit Docker container

control + p + q

Try connecting with Navicat

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.