使用Docker部署Mysql数据库
小破站老大
2022-12-12 AM
567℃
0条
docker run -dit --name mysql -p 30060:3306 -e MYSQL_ROOT_PASSWORD=123456789 -e TZ=Asia/Shanghai -v /data/mysql/config:/etc/mysql/conf.d -v /data/mysql/data:/var/lib/mysql mysql:5.7.19 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
touch /data/mysql/config/my.cnf
[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
[mysqld]
skip-ssl
max_connections = 2000
secure_file_priv=/var/lib/mysql
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
docker restart mysql