You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
1.3 KiB
1.3 KiB
MYSQL 安装
配置路径
mkdir -p /usr/local/mysql/{script,data}
cat > /usr/local/mysql/script/init.sql <<'EOF'
CREATE DATABASE IF NOT EXISTS `camunda` DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_general_ci;
EOF
COMPOSE 文件
cat > /usr/local/mysql/docker-compose.yml <<'EOF'
version: '3'
services:
mysql:
image: mysql:8.0.20
restart: always
container_name: mysql
environment:
MYSQL_USER: root
MYSQL_PASSWORD: 123456
MYSQL_ROOT_PASSWORD: 123456
command:
--default-authentication-plugin=mysql_native_password
--character-set-server=utf8mb4
--collation-server=utf8mb4_general_ci
--explicit_defaults_for_timestamp=true
--lower_case_table_names=1
ports:
- 3306:3306
volumes:
- ./data:/var/lib/mysql
- ./script/init.sh:/docker-entrypoint-initdb.d/init.sh
- /etc/localtime:/etc/localtime:ro
EOF
启动
cd /usr/local/mysql/ && docker-compose up -d
配置
进入容器
docker exec -it mysql /bin/bash
登录
mysql -u root -p
开启权限
use mysql;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;
退出登录
\q
退出容器
exit