You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
docker run -d --name mysql -p 3306:3306 -v ~/docker/mysql/conf/:/etc/mysql/conf.d -v ~/docker/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=12345666 mysql
进入容器修改密码
进入容器
docker exec -it mysql bash
链接mysql,输入上面的密码
mysql -u root -p
更改密码
Use mysql;
Updatemysql.userset authentication_string=password('xxxxxx') where user='root'and host='%';
flush privileges;
创建mysql新用户
createuser 'bitjian'@'%' identified by 'your_password;grant select,update,delete,insert on bitjian.* to bitjian@'%' identified by 'your_password';flush privileges;
问题总结
不设置自定义配置文件mysql时间戳默认早8小时
查看容器映射后的本地目录,数据文件都复制到本地了
查看容器挂载目录,本地文件也挂载到容器里了
The text was updated successfully, but these errors were encountered:
docker部署--mysql
安装mysql镜像(默认最新版本)
mysql中docker相关目录与映射目录
运行容器并映射目录和密码
进入容器修改密码
docker exec -it mysql bash
创建mysql新用户
问题总结
The text was updated successfully, but these errors were encountered: