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