docker安装mysql

docker pull mysql:5.7

 docker images

docker run -p 3311:3306  --privileged=true -v /zzyyuse/mysql/log:/var/log/mysql -v /zzyyuse/mysql/data:/var/lib/mysql -v /zzyyuse/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7

 

cd /zzyyuse/mysql/conf

ls
vim my.cnf

 

 

 解决mysql中文乱码

[client]
default_character_set=utf8
[mysqld]
collation_server = utf8_general_ci
character_set_server = utf8

docker ps
docker restart 896a067d639f

 

docker exec -it 896a067d639f /bin/bash

 

 

mysql -uroot -p123456

show variables like 'character%';

 

show databases;

create database db01;

use db01;

create table t1(id int,name varchar(32));

insert into t1 values(1,"zhangsan");

select * from t1;

（重新打开一个终端）

ifconfig 

 

 去navicate链接