默认官方的mysql镜像有权限问题,可以自己制作个mysql镜像
FROM mysql:8.0
RUN chown -R mysql:root /var/lib/mysql/
RUN chmod -R 775 /var/lib/mysql
构建镜像
docker build -t mysqlimg:8.0 .
mysql设置密码
use mysql;
update user set host='%' where user='root';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;