1.下载mysql
docker pull mysql
2.docker运行mysql
docker run -d -p 3306:3306 --privileged=true -v /opt/mysql/log:/var/log/mysql -v /opt/mysql/data:/var/lib/mysql -v /opt/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=****** --name mysql mysql
3.进入mysql容器
docker exec -it 8770feff5089 /bin/bash
4.使用mysql
mysql -uroot -p
5.建库建表插入数据
create database test;
use test;
create table a(id int,name varchar(20),age int);
insert into a values(1,‘张三’,10);
select * from a;
发现有中文乱码
1.新建my.cnf文件
[client]
default_character_set=utf8
[mysqld]
collation_server = utf8_general_ci
character_set_server = utf8
2.重启mysql
3.重新查询数据发现已经没有乱码