Docker 安装部署
简单部署
docker search mysql
docker pull mysql:5.7
docker run -p 3307:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7
docker ps
docker exec -it [容器ID]
mysql -uroot -p123456
create table user(id int,name varchar(20));
use db1;
insert into user values(1,'zs');
select * from user;
解决数据持久化存储的问题
docker run -d -p 3307:3306 --privileged=true -v /subai/mysql/log:/var/log/mysql -v /subai/mysql/data:/var/lib/mysql -v /subai/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=123456 mysql:5.7
[client]
default_character_set=utf8
[mysqld]
collation_server = utf8_general_ci
character_set_server = utf8
docker restart 容器id
SHOW VARIABLES LIKE 'character%';