当前位置:网站首页>【Docker】Docker安装MySQL
【Docker】Docker安装MySQL
2022-08-09 06:46:00 【L-DiCaprio】
1.docker pull 安装mysql:
docker pull mysql
2.运行mysql容器:
docker run -p 3306:3306 --privileged=true -v /root/mysql/log:/var/log/mysql -v /root/mysql/data:/var/lib/mysql -v /root/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=123456 --name mysql -d mysql:5.7
3.配置mysql配置文件,解决中文乱码:
vi /root/mysql/conf/my.conf
[client]
default_character_set=utf8
[mysql]
collation_server=utf8_general_ci
character_set_server=utf8
建库建表插入数据:
create database db01;
use db01;
create table t1(id int,name varchar(20));
insert into t1 values(1,'z3');
边栏推荐
猜你喜欢
ByteDance Written Exam 2020 (Douyin E-commerce)
Inception V3 Eye Closure Detection
线程的6种状态
leetcode 之 70 爬楼梯问题 (斐波那契数)
Built-in macros in C language (define log macros)
Altium designer software commonly used the most complete package library, including schematic library, PCB library and 3D model library
CMake中INSTALL_RPATH与BUILD_RPATH问题
pycharm环境包导入到另外一个环境
力扣第 305 场周赛复盘
使用百度EasyDL实现智能垃圾箱
随机推荐
vim 程序编辑器的基本操作(积累)
锁执行的过程
按图搜索1688商品接口(item_search_img-按图搜索1688商品(拍立淘接口)代码对接教程
Inception V3 闭眼检测
TCP segment of a reassembled PDU
像天才一样思考:如何培养自己的创造力?
Introduction and use of BeautifulSoup4
ByteDance Written Exam 2020 (Douyin E-commerce)
默默重新开始,第一页也是新的一页
抗菌药物丨Toronto Research Chemicals 天冬酰胺D
mysql 总结
移远EC20 4G模块拨号相关
逆向工程
leetcode 之盛水问题
代码目录结构
Flask failed to create database without error
2017.10.26模拟 b energy
C language implements sequential stack and chain queue
XxlJobConfig分布式定时器任务管理XxlJob配置类,替代
dp学习笔记