docker安装mysql

Pull mysql

docker pull mysql

Start a mysql instance

docker run --name some-mysql -p 3306:3306  -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag
#my cmd
docker run --name sql01 -p 3306:3306  -e MYSQL_ROOT_PASSWORD=123456 -d mysql

修改加密方式

#查看root用户加密方式
select user,plugin,host from user where user = 'root';
#如果加密方式为 caching_sha2_password 
#则修改为mysql_native_password并修改密码
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; 
#刷新权限使命令生效
flush privileges；

docker mysql 5.5 修改默认字符集

#进入容器
docker exec -it mysql bash
#修改配置文件
cd /etc/mysql
vim my.cnf

#添加以下内容
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=utf8
[mysqld]
skip-host-cache
skip-name-resolve
datadir = /var/lib/mysql
!includedir /etc/mysql/conf.d/

port = 3306
socket = /var/lib/mysql/mysql.sock
character-set-server=utf8

[mysql]
no-auto-rehash
default-character-set=utf8