docker-compose.yml
version: '3'
services:
mysql-db-dev:
container_name: mysql-docker-dev # 指定容器的名稱
image: mysql:8.0 # 指定鏡像和版本
ports:
- "33062:3306"
environment:
MYSQL_ROOT_PASSWORD: 123456
#env_file: 設(shè)置環(huán)境變量文件
# - .env
volumes:
- ./data:/var/lib/mysql" # 掛載數(shù)據(jù)目錄
- ./conf.d:/etc/mysql/conf.d" # 掛載配置文件目錄
- ./my.cnf:/etc/my.cnf
my.cnf 設(shè)置字符集為utf8mb4 解決emoji表情等特殊字符存儲問題
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
docker-compose up -d
安裝后嘗試 mysql 127.0.0.1 -P33062 -uroot -p'123456' 報錯
RROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
解決辦法
docker ps 找到對應(yīng)容器ID
docker exec -it container_id /bin/sh
mysql -h127.0.0.1 -uroot -p'123456'
alter user 'root'@'%' identified with mysql_native_password by '123456';
重新登陸mysql即可
