Docker 部署 MySql 并修改为大小写不敏感

部署 mysql

docker run --name mysql --restart=always -p 3306:3306  -v /data/mysql:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=12345678 -d mysql:5.7
​

调整 mysql 为大小写不敏感

1、 进入 docker 容器 mysql

docker exec -it mysql  /bin/bash
​

2、配置镜像源安装 VIM

mv /etc/apt/sources.list /etc/apt/sources.list.bak 
echo "deb http://mirrors.163.com/debian/ jessie main non-free contrib" >/etc/apt/sources.list 
echo "deb http://mirrors.163.com/debian/ jessie-proposed-updates main non-free contrib" >>/etc/apt/sources.list 
echo "deb-src http://mirrors.163.com/debian/ jessie main non-free contrib" >>/etc/apt/sources.list 
echo "deb-src http://mirrors.163.com/debian/ jessie-proposed-updates main non-free contrib" >>/etc/apt/sources.list 
#更新安装源 
apt-get update 
#如果下载过程中卡在[waiting for headers] 删除/var/cache/apt/archives/下的所有文件 
#安装vim 
apt-get install vim
​

3、编辑/etc/mysql/mysql.conf.d/mysqld.cnf 文件

#[mysqld]后添加 
lower_case_table_names=1
​

4、重启应用

#容器中执行
service mysql restart

#或者退出容器直接重启mysql容器
docker restart mysql
​