Skip to content
docker install mysql
2025年3月13日 root

pull image

shell
docker pull mysql/mysql-server:8.0

run mysql server

shell
docker run --name=mysql-demo \
   -v ~/mysql/conf.d:/etc/mysql/conf.d \
   -v ~/mysql/mysql-data:/var/lib/mysql \
   -e MYSQL_ROOT_PASSWORD=123456 \
   -p 3306:3306 -d mysql/mysql-server:8.0

add remote user access

mysql
docker exec -it mysql-demo mysql -uroot -p
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';
GRANT ALL ON *.* TO 'myuser'@'%';
FLUSH PRIVILEGES;

change config

shell
vi ~/mysql/conf.d/myconfig
config
bind-address = 0.0.0.0

restart mysql

shell
docker restart mysql-demo

Last updated: