dockercompose配置jira连接mysql失败

dockercompose启动jira，mysql

参考下面文章进行安装：https://blog.csdn.net/weixin_37558119/article/details/113246972
https://blog.csdn.net/weixin_37558119/article/details/113246972
dockercompose文件：

services:
  mysql:
    image: mysql/mysql-server:5.7
    container_name: yanfa_mysql
    restart: always
    ports:
      - "3306:3306"
    volumes:
      - ./mysql/data:/var/lib/mysql
      - ./mysql/conf/my.cnf:/etc/mysql/my.cnf
    environment: 
      MYSQL_ROOT_PASSWORD: 123456
      MYSQL_ROOT_HOST: "%"
    networks:
      - esnet  

  jira:
    image: atlassian/jira-software:8.5.1
    container_name: jira
    restart: always
    ports:
      - "8080:8080"
    environment:
      CATALINA_OPTS: -javaagent:/opt/atlassian/jira/atlassian-agent.jar  
    volumes:
      - ./jira/data:/var/atlassian/application-data/jira
      - ./libs/mysql-connector-java-5.1.42.jar:/opt/atlassian/jira/lib/mysql-connector-java.jar
      - ./libs/atlassian-agent.jar:/opt/atlassian/jira/atlassian-agent.jar
    networks:
      - esnet  
networks:
  esnet:     
      

包文件可以上面链接文章中找到。

jira启动后配置数据库出错

jira进行数据库连接测试错误，出现了红色提示：Establishing SSL connection without server‘s identity verification is not recommended.等
查看docker mysql日志出现了BAD HANDSHAKE的提示，说明数据库地址是对的。
因为客户端对mysql5.7以上连接时要加上useSSL=true或者false,jira连接mysql没有设置，不知道是不是版本问题。

解决方法

docker mysql载入自己编写的配置文件my.cnf，跳过mysql的ssl验证，添加：

# disable_ssl
skip_ssl

栗子：

[client]
port = 3306
socket = /var/lib/mysql/data/mysql.sock
[mysqld]
# disable_ssl
skip_ssl
 # 针对5.7版本执行group by字句出错问题解决
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
 # 一般配置选项
basedir = /var/lib/mysql
datadir = /var/lib/mysql/data
port = 3306
socket = /var/lib/mysql/data/mysql.sock
lc-messages-dir = /usr/share/mysql # 务必配置此项，否则执行sql出错时，只能显示错误代码而不显示具体错误消息
character-set-server=utf8mb4
back_log = 300
max_connections = 3000
max_connect_errors = 50
table_open_cache = 4096
max_allowed_packet = 32M
#binlog_cache_size = 4M
max_heap_table_size = 128M
read_rnd_buffer_size = 16M
sort_buffer_size = 16M
join_buffer_size = 16M
thread_cache_size = 16
query_cache_size = 64M
query_cache_limit = 4M
ft_min_word_len = 8
thread_stack = 512K
#tx_isolation = READ-COMMITTED
tmp_table_size = 64M
#log-bin=mysql-bin
long_query_time = 6
server_id=1
innodb_buffer_pool_size = 1024M
innodb_thread_concurrency = 16
innodb_log_buffer_size = 16M
wait_timeout= 31536000
interactive_timeout= 31536000
lower_case_table_names = 1