Centos8安装docker及docker运行mysql8的问题

安装docker (centos8)

安装docker所需依赖

yum install -y yum-utils device-mapper-persistent-data lvm2

添加阿里云仓库

yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo

安装docker

yum -y install docker-ce

启动docker

systemctl start docker

将docker设置为开机启动

systemctl enable docker

在docker中操作mysql8

拉取mysql 8 镜像

docker pull mysql:8.0.16

假如报错

Error response from daemon: Get "https://registry-1.docker.io/v2/": net/http: TLS handshake timeout

更改配置源
编辑或新建配置文件 /etc/docker/daemon.json（daemon.json）

{
    "registry-mirrors": ["https://registry.docker-cn.com","http://hub-mirror.c.163.com"],
    "live-restore": true
}

创建挂在卷目录

mkdir -p /home/mysql/conf
mkdir -p /home/mysql/data
mkdir -p /home/mysql/logs

在/home/mysql/conf 创建my.cnf 文件

vim /home/mysql/conf/my.cnf

my.cnf

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
secure-file-priv= NULL
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Custom config should go here
!includedir /etc/mysql/conf.d/
log-error=/var/log/mysql/error.log
#log=/var/log/mysql/mysql.log
slow_query_log =ON
slow_query_log_file=/var/log/mysql/slowquery.log
long_query_time=3
log-queries-not-using-indexes=/var/log/mysql/nouseindex.log
lower_case_table_names=1
default_authentication_plugin=mysql_native_password

[client]
default-character-set=utf8
 
[mysql]
default-character-set=utf8

启动docker

docker run  -d -v /home/mysql/conf/my.cnf:/etc/mysql/conf/my.cnf -v /home/mysql/logs:/logs -v /home/mysql/data/mysql:/var/lib/mysql -p 3306:3306 --name mysql -e MYSQL_ROOT_PASSWORD=123456 mysql:8.0.16

设置主机访问

进入docker

docker exec -it 实例id /bin/bash
//链接msql
mysql -uroot -p
//修改访问主机以及密码等，设置为所有主机可访问

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
#刷新权限
flush privileges;

2059 问题看主页mysql 2059的文章