Docker安装mysql-爱代码爱编程
Docker安装mysql
Pull镜像:
docker pull mysql:8.0.18
运行容器:
docker run -p 3306:3306
–name mysql
-v $PWD/mydate/mysql/conf:/etc/mysql/conf.d
-v $PWD/mydate/mysql/logs:/logs
-v $PWD/mydate/mysql/data:/var/lib/mysql
-e MYSQL_ROOT_PASSWORD=123456
-d mysql:8.0.18
进入容器开启远程访问权限:
docker exec -it mysql bash
登录:
mysql -uroot -p
输入密码:
123456
开启远程访问权限:
use mysql;
select host,user from user;
ALTER USER ‘root’@‘%’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
flush privileges;