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安装dockeryum
·
安装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的文章
更多推荐
已为社区贡献1条内容
所有评论(0)