Docker安装mysql

Docker安装mysql

注意事项：创建文件时需要在 / 根目录下面

1. 创建挂载路径

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

2. 新建my.cnf（放到conf文件下面）

[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

4. 修改权限

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

5. 远程连接数据库 navicat报错10060 /2003为mysql远程服务未开启

systemctl stop firewalld
systemctl status firewalld
systemctl restart firewalld