docker安装mysql

一、拉取

docker pull mysql:5.7

二、启动

docker run -p 3306:3306 --name mysql --restart=always -v /home/docker/mysql/conf:/etc/mysql/ -v  /home/docker/mysql/logs:/logs -v  /home/docker/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d docker.io/mysql

三、配置

docker exec -it 62349aa31687 /bin/bash
mysql -uroot -p
grant all on *.* to 'root'@'%';
alter user 'root'@'localhost' identified by 'password' password expire never;
alter user 'root'@'%' identified with mysql_native_password by '123456';
flush privileges;