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

安装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

拉取mysql 8 镜像

docker pull mysql:8.0.16

创建挂在卷目录

mkdir /home/mysql/conf
mkdir /home/mysql/data
mkdir /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 'root';
#刷新权限
flush privileges;

如果有1045就执行下面这句
注意：123456 为root的密码

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';