配置簡(jiǎn)述
/etc/mysql/my.cnf #用于存儲(chǔ)默認(rèn)配置（有具體默認(rèn)配置信息），mysq5.7這個(gè)配置文件里面引用了2個(gè)目錄，用于配置默認(rèn)配置和自定義配置
/etc/mysql/conf.d # 自定義添加修改配置信息配置
/var/lib/mysql #數(shù)據(jù)存放目錄
mkdir -p /app/mysql/data
mkdir -p /app/mysql/conf
mkdir -p /app/mysql/sql
chmod -R
777 /app/mysql/
docker run --name mysql-8.0.27
\
-d
\
-p
3306:3306
\
-v /app/mysql/data:/var/lib/mysql
\
-v /app/mysql/conf:/etc/mysql/conf.d
\
-e
MYSQL_ROOT_PASSWORD=123456 \
--restart always
\
--privileged
=true
\
mysql:8.0.27
- 創(chuàng)建mysql容器并指定mysql容器編碼
docker run --name mysql-8.0.27
\
-d
\
-p
3306:3306
\
-v /app/mysql/data:/var/lib/mysql
\
-v /app/mysql/conf:/etc/mysql/conf.d
\
-e
MYSQL_ROOT_PASSWORD=123456 \
--restart always
\
--privileged
=true
\
mysql:8.0.27
\
--character-set-server
=utf8mb4
\
--collation-server
=utf8mb4_unicode_ci
- 啟動(dòng)容器過(guò)程中創(chuàng)建指定數(shù)據(jù)庫(kù)
docker run --name mysql-8.0.27
\
-d
\
-p
3306:3306
\
-v /app/mysql/data:/var/lib/mysql
\
-v /app/mysql/conf:/etc/mysql/conf.d
\
-e
MYSQL_ROOT_PASSWORD=123456 \
-e
MYSQL_DATABASE=gblfy
\
--restart always
\
--privileged
=true
\
mysql:8.0.27
\
--character-set-server
=utf8mb4
\
--collation-server
=utf8mb4_unicode_ci
- 啟動(dòng)容器過(guò)程中創(chuàng)建指定數(shù)據(jù)庫(kù)，執(zhí)行對(duì)應(yīng)的sql文件
容器中執(zhí)行sq的腳本目錄：/docker-entrypoint-initdb.d
docker run --name mysql-8.0.27
\
-d
\
-p
3306:3306
\
-v /app/mysql/data:/var/lib/mysql
\
-v /app/mysql/conf:/etc/mysql/conf.d
\
-v /app/mysql/sql/sys_user.sql:/docker-entrypoint-initdb.d/sys_user.sql
\
-e
MYSQL_ROOT_PASSWORD=123456 \
-e
MYSQL_DATABASE=gblfy
\
--restart always
\
--privileged
=true
\
mysql:8.0.27
\
--character-set-server
=utf8mb4
\
--collation-server
=utf8mb4_unicode_ci
SET NAMES utf8mb4
;
SET FOREIGN_KEY_CHECKS
= 0;-- ----------------------------
-- Table structure
for sys_user
-- ----------------------------
DROP TABLE IF EXISTS
`sys_user`;
CREATE TABLE
`sys_user` (`user_id` bigint NOT NULL AUTO_INCREMENT COMMENT
'用戶(hù)ID',
`dept_id` bigint NULL DEFAULT NULL COMMENT
'部門(mén)ID',
`user_name` varchar
(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT
'用戶(hù)賬號(hào)',
`nick_name` varchar
(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT
'用戶(hù)昵稱(chēng)',
`user_type` varchar
(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT
'00' COMMENT
'用戶(hù)類(lèi)型（00系統(tǒng)用戶(hù)）',
`email` varchar
(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT
'' COMMENT
'用戶(hù)郵箱',
`phonenumber` varchar
(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT
'' COMMENT
'手機(jī)號(hào)碼',
`sex` char
(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT
'0' COMMENT
'用戶(hù)性別（0男 1女 2未知）',
`avatar` varchar
(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT
'' COMMENT
'頭像地址',
`password` varchar
(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT
'' COMMENT
'密碼',
`status` char
(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT
'0' COMMENT
'帳號(hào)狀態(tài)（0正常 1停用）',
`del_flag` char
(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT
'0' COMMENT
'刪除標(biāo)志（0代表存在 2代表刪除）',
`login_ip` varchar
(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT
'' COMMENT
'最后登錄IP',
`login_date` datetime NULL DEFAULT NULL COMMENT
'最后登錄時(shí)間',
`create_by` varchar
(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT
'' COMMENT
'創(chuàng)建者',
`create_time` datetime NULL DEFAULT NULL COMMENT
'創(chuàng)建時(shí)間',
`update_by` varchar
(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT
'' COMMENT
'更新者',
`update_time` datetime NULL DEFAULT NULL COMMENT
'更新時(shí)間',
`remark` varchar
(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT
'備注',PRIMARY KEY
(`user_id`) USING BTREE
) ENGINE
= InnoDB AUTO_INCREMENT
= 100 CHARACTER SET
= utf8mb4 COLLATE
= utf8mb4_unicode_ci COMMENT
= '用戶(hù)信息表' ROW_FORMAT
= Dynamic
;-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO
`sys_user` VALUES
(1,
1,
'gblfy專(zhuān)家',
'gblfy',
'00',
'gblfy@163.com',
'',
'0',
'',
'',
'0',
'0',
'', NULL,
'', NULL,
'', NULL, NULL
);
- 啟動(dòng)容器過(guò)程中創(chuàng)建指定數(shù)據(jù)庫(kù)，指定root密碼，創(chuàng)建指定mysql用戶(hù)并指定密碼，執(zhí)行對(duì)應(yīng)的sql文件
容器中執(zhí)行sq的腳本目錄：/docker-entrypoint-initdb.d
docker run --name mysql-8.0.27
\
-d
\
-p
3306:3306
\
-v /app/mysql/data:/var/lib/mysql
\
-v /app/mysql/conf:/etc/mysql/conf.d
\
-v /app/mysql/sql/sys_user.sql:/docker-entrypoint-initdb.d/sys_user.sql
\
-e
MYSQL_ROOT_PASSWORD=123456 \
-e
MYSQL_DATABASE=gblfy
\
-e
MYSQL_USER=gblfy
\
-e
MYSQL_PASSWORD=gblfy
\
--restart always
\
--privileged
=true
\
mysql:8.0.27
\
--character-set-server
=utf8mb4
\
--collation-server
=utf8mb4_unicode_ci
mkdir -p /app/mysql/conf
mkdir -p /app/mysql/logs
mkdir -p /app/mysql/data
chmod -R
777 /app/mysql/docker run --name mysql5.7 -d
\
-p
3306:3306
\
-v /app/mysql/conf:/etc/my.cnf.d
\
-v /app/mysql/logs:/logs
\
-v /app/mysql/data:/var/lib/mysql
\
-e
MYSQL_ROOT_PASSWORD=123456 \
--restart always
\
--privileged
=true
\
mysql:5.7docker logs -f mysql5.7
總結(jié)
以上是生活随笔為你收集整理的docker mysql:8.0.27的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。
如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。
