1.docker pull 安装mysql:
docker pull mysql
2.运行mysql容器:
docker run -p 3306:3306 --privileged=true -v /root/mysql/log:/var/log/mysql -v /root/mysql/data:/var/lib/mysql -v /root/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=123456 --name mysql -d mysql:5.7
3.配置mysql配置文件,解决中文乱码:
vi /root/mysql/conf/my.conf
[client]
default_character_set=utf8
[mysql]
collation_server=utf8_general_ci
character_set_server=utf8
建库建表插入数据:
create database db01;
use db01;
create table t1(id int,name varchar(20));
insert into t1 values(1,'z3');