Appearance
docker search mysql查找mysqldocker pull mysql:版本号(选填)docker run -p 3306:3306 --name mysql -v /sun/mysql/conf:/ect/mysql/conf.d -v /sun/mysql/logs:/logs -v /sun/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:8.5.20- 命令说明:
-p3306:3306将主机端口映射到docker容器的3306端口上–name mysql运行服务的名字-v /sun/mysql/conf:/ect/mysql/conf.d将主机/sun/mysql/conf目录下挂载到etc/mysql/conf.d-v /sun/mysql/logs:/logs挂载到容器/logs-e MYSQL_ROOT_PASSWORD=123456初始化root密码-d mysql:8.5.20后台运行
- 命令说明:
- 注:由于mysql8.0以上密码的加密方式不一样,所以修改之后才能连接数据库
docker exec -it mysql /bin/bash进入容器mysql -uroot -password#登录use mysql;#选择数据库ALTER USER 'root'@'localhost' IDENTIFIED BY ‘password’ PASSWORD EXPIRE NEVER;#更改加密方式ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';#更新用户密码FLUSH PRIVILEGES;#刷新权限- 远程连接将'localhost'换成'%'