docker 默认mysql版本为8.0
docker pull mysql
启动mysql8
首先需要新建目录及文件
文件:F:\mydocker\mysql8\config\my.cnf
目录:F:\mydocker\mysql8\data
文件:F:\mydocker\mysql8\etc\localtime
目录:F:\mydocker\mysql8\log
构建容器命令:
docker run -p 3307:3306 -e MYSQL_ROOT_PASSWORD=123456 -v F:\mydocker\mysql8\data:/var/lib/mysql-files:rw -v F:\mydocker\mysql8\log:/var/log/mysql:rw -v F:\mydocker\mysql8\etc\localtime:/etc/localtime:ro -v F:\mydocker\mysql8\config\my.cnf:/etc/mysql/my.cnf:rw --name mysql8 --restart=always -d mysql
进入容器
docker exec -it mysql8 bash
安装vim(可选)
- apt-get update
- apt-get install vim
配置mysql(支持远程连接,Navicate)
mysql -uroot -p
use mysql;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'newpassword';
flush privileges;
查询用户信息
select host,user,plugin,authentication_string from mysql.user;