docker安装mysql8

1.创建挂载路径

mkdir -p /docker/mysql/conf /docker/mysql/data /docker/mysql/logs

2.新建my.cnf

[client]

#socket = /usr/mysql/mysqld.sock

default-character-set = utf8mb4

[mysqld]

#pid-file        = /var/run/mysqld/mysqld.pid

#socket          = /var/run/mysqld/mysqld.sock

#datadir         = /var/lib/mysql

#socket = /usr/mysql/mysqld.sock

#pid-file = /usr/mysql/mysqld.pid

character_set_server = utf8mb4

collation_server = utf8mb4_bin

secure-file-priv= NULL

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

# Custom config should go here

!includedir /etc/mysql/conf.d/

3.创建容器

docker run --name mysql \
    -v /docker/mysql/conf/my.cnf:/etc/mysql/my.cnf \
    -v /docker/mysql/data:/var/lib/mysql \
    -v /docker/mysql/logs:/var/log/mysql \
    -p 3306:3306 \
    -e MYSQL_ROOT_PASSWORD=123456 \
    -d mysql:8.0.25

4.修改权限

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

FLUSH PRIVILEGES;

5.测试