docker 安装mysql
拉起MySQL镜像(:5.7 表示5.7版本) o docker pull mysql:5.7
docker run -d -p 3306:3306 --name mysql -e MYSQL_ROOT_PASSWORD=123 mysql:5.7
//这里为了查看配置文件存放路径
docker exec -it mysql bash
mysql -uroot -p
//show variables like '%datadir%';会输出数据文件的存放路径 /var/lib/mysql/
show variables like '%datadir%';
//拷贝容器配置文件,配置文件存在 /etc/mysql
docker cp mysql:/etc/mysql /etc/docker
//拷贝my.cnf文件
docker cp mysql:/etc/mysql/my.cnf /etc/docker/mysql/conf
//复制完成删除容器,先停才能删除
docker stop mysql
docker rm mysql
[mysqld]
character-set-server=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
docker run -d -p 3306:3360 --restart always -e TZ=Asia/Shanghai -e MYSQL_ROOT_PASSWORD="ztan123456" -e MYSQL_USER="ztan" -e MYSQL_PASSWORD="ztan123456" -v /etc/docker/mysql/conf/my.cnf:/etc/my.cnf -v /etc/docker/mysql/data:/var/lib/mysql --name mysql01 mysql:5.7 --character-set-server=utf8mb4 --collation-server=utf8mb4_general_ci
docke exec
mysql
docker exec -it mysql01 bash
//进入mysql
msyql -uroot -p
//授权
GRANT ALL ON *.* TO 'root'@'%';
//刷新权限
flush privileges;
//更新加密规则 可设置弱智密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
//更新密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
docker logs mysql01