docker安装MySQL

最新推荐文章于 2024-10-16 20:25:28 发布

唐国建

最新推荐文章于 2024-10-16 20:25:28 发布

阅读量97

点赞数

文章标签： docker mysql

本文链接：https://blog.csdn.net/weixin_42654707/article/details/120887131

版权

安装docker

yum install docker

启动docker

systemctl start docker

从阿里云中更换镜像

mkdir -p /etc/docker
tee /etc/docker/daemon.json <<-'EOF'
   {
   "registry-mirrors": ["https://xt6qy6i8.mirror.aliyuncs.com"]
   }
   EOF
systemctl daemon-reload
systemctl restart docker

docker拉取MySQL镜像

docker pull mysql:版本
docker run -p 3306:3306 --name mysql --privileged=true -v /mydata/mysql/log:/var/log/mysql -v /mydata/mysql/data:/var/lib/mysql -v /mydata/mysql/conf:/etc/mysql -e MYSQL_ROOT_PASSWORD=root -d mysql:mysql的版本

修改允许任意主机通过外网访问MySQL

docker环境中进入MySQL:docker exec -it mysql镜像的CONTAINER ID /bin/bash
MySQL用户名密码登录：mysql -uroot -proot
使用MySQL数据库(8.0版本以上)：mysql>use mysql;
               mysql>update user set host = '%' where user ='root';
               mysql>select host, user from user;
               mysql>flush privileges;
               mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'root';
               mysql>ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
               mysql>flush privileges;
5.7版本使用：GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'  IDENTIFIED BY 'root'  WITH GRANT OPTION;               
使用连接数据库工具连接即可