大家好,我是walker
一个从文科自学转行的程序员~
爱好编程,偶尔写写编程文章和生活
欢迎关注公众号【I am Walker】,回复“电子书”,就可以获得200多本编程相关电子书哈~
我的gitee:https://gitee.com/shen-chuhao/walker.git 里面很多技术案例!
参考:https://www.cnblogs.com/-wenli/p/14233010.html
文件目录结构
/Mysql # Mysql应用文件夹
docker-compose.yml # docker compose脚本文件
init.sql # mysql初始sql文件
/conf # 配置文件夹
my.cnf # 配置文件
/db # 数据库文件
操作过程
1、创建配置文件
docker-compose.yml
version: '3'
services:
mysql:
network_mode: "bridge"
environment:
# root账号的密码
MYSQL_ROOT_PASSWORD: "yourpassword"
# user的账号密码,这里的账号不能设置为root
MYSQL_USER: 'test'
MYSQL_PASS: 'yourpassword'
image: "mysql:5.7"
restart: always
volumes:
- "./db:/var/lib/mysql"
- "./conf/my.cnf:/etc/my.cnf"
- "./init:/docker-entrypoint-initdb.d/"
ports:
- "3306:3306"
my.cnf
[mysqld]
user=mysql
default-storage-engine=INNODB
character-set-server=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
init.sql
初始账户sql,也可以不弄
create database test;
use test;
create table user
(
id int auto_increment primary key,
username varchar(64) unique not null,
email varchar(120) unique not null,
password_hash varchar(128) not null,
avatar varchar(128) not null
);
insert into user values(1, "zhangsan","test12345@qq.com","passwd","avaterpath");
insert into user values(2, "lisi","12345test@qq.com","passwd","avaterpath");
2、执行命令
docker-compose up -d
3、查看docker并进入mysql
docker ps
查看容器
docker exec -it bdc723 /bin/bash
进入容器
mysql -u root -p
执行sql