docker 部署单机mysql 及mysql-connector

一：docker 部署单机mysql

安装mysql服务(给nacos组件服务）

cd /data/mysql

#安装mysql client命令行

apt install mariadb-client

#导入mysql镜像

docker load < mysql.8.0.31.tgz

#nerdctl load < mysql.8.0.31.tgz

#创建目录

mkdir -p /data/mysql/{data,init}

#my.cnf配置

vi /data/mysql/my.cnf

[client]default-character-set = utf8mb4[mysql]default-character-set = utf8mb4[mysqld]#character_set_server=utf8mb4skip_ssl # 忽略sslcharacter-set-server = utf8mb4init_connect='SET NAMES utf8'skip-host-cacheskip-name-resolvedatadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.socksecure-file-priv=/var/lib/mysql-filesmax_connections=4096user=mysqlserver-id=1symbolic-links=7binlog_format=ROWlog-bin=mysql-binexpire_logs_days=30log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pidslow_query_log = ONslow_query_log_file = /var/lib/mysql/slow.loglong_query_time = 1log_output = FILEgroup_concat_max_len=102400000max_allowed_packet=100Mwait_timeout=2880000interactive_timeout=2880000innodb_log_file_size=640M

#docker-compose.yaml配置文件

version: '3.8'services: mysql: hostname: mysql image: mysql:8.0.31 volumes: - /data/mysql/my.cnf:/etc/mysql/my.cnf - /data/mysql/data:/var/lib/mysql - /data/mysql/init/:/docker-entrypoint-initdb.d/ - /etc/localtime:/etc/localtime:ro ports: - target: 3306 published: 3306 protocol: tcp mode: host command: --default-authentication-plugin=mysql_native_password environment: MYSQL_ROOT_PASSWORD: Aa456123 networks: - metanetworks: meta: external: true

启动服务

docker-compose up -d

#nerdctl compose up -d

查看服务

docker ps

#nerdctl ps |grep mysql

访问验证：

mysql -uroot -pAa456123 -h192.168.10.20

二：mysql-connector

mysql-connector

1.下载

https://downloads.mysql.com/archives/c-j/

2.安装

mysql-connector-j_8.0.31-1ubuntu22.10_all.deb

3.文件路径