docker for mysql
1.查看仓库支持版本：https://hub.docker.com/search?q=&type=image
2.拉起mysql 镜像：
$ sudo docker pull mysql:5.7 3. 运行镜像：
$ sudo docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=yzyx@123 -d mysql:5.7 4.进入容器：
$ sudo docker exec -it c3abba1c982d /bin/bash 5.数据库登录：
mysql -u root -p 6.查看&修改数据库字符集
show create database eric;
7.查看mysql 配置文件
cd /etc/mysql/
cd mysql.conf.d/
pid-file= /var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
datadir= /var/lib/mysql
symbolic-links=0 8.创建挂载目录的宿主机文件夹
$ mkdir -p mysql/conf
$ mkdir -p mysql/data
$ mkdir -p mysql/logs 9.修改mysql字符集
$ sudo vi mysqld.cnf# By default we only accept connections from localhost
#bind-address = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
character-set-server=utf8
10.重新启动
$ sudo docker run \
> --name mysql \
> -p 3306:3306 \
> -v /home/python/mysql/conf/:/etc/mysql/mysql.conf.d/ \
> -v /home/python/mysql/data/:/var/lib/mysql \
> -v /home/python/mysql/logs/:/logs \
> -e MYSQL_ROOT_PASSWORD=yzyx@123 \
> -d mysql:5.7
页:
[1]