关于使用docker-compose部署nacos与mysql8.0之后nacos连接不上mysql的问题

qq_39425757

已于 2022-03-30 14:02:09 修改

阅读量4.2k

点赞数

分类专栏： Linux 文章标签： java linux docker

于 2022-03-30 14:01:44 首次发布

本文链接：https://blog.csdn.net/qq_39425757/article/details/123843830

版权

Linux 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

项目场景：

使用docker-compose来对安装部署的docker进行统一管理。

问题描述

在使用docker-compose restart命令一键启动时，nacos在连接mysql8.0的时候出现了问题，再考虑到有可能是mysql版本之后更改为mysql5.7版本连接没出现问题。

Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'asyncNotifyService': Unsatisfied dependency expressed through field 'dumpService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalDumpService': Invocation of init method failed; nested exception is ErrCode:500, ErrMsg:Nacos Server did not start because dumpservice bean construction failure :
No DataSource set
        at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:598)
        at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:90)
        at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:376)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1402)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:591)
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:514)
        at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:321)
        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:319)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
        at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:277)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1276)
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1196)
        at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:857)
        at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:760)
        ... 27 common frames omitted

原因分析：

在重新给其他服务器部署运行环境时，了解到mysql8.0与mysql5.7的密码认证插件不一样，mysql5.7使用的是mysql_native_password ，而mysql8.0使用的是caching_sha2_password 。

解决方案：

将mysql8.0的默认认证插件caching_sha2_password 更改为mysql_native_password 。

一、安装部署mysql8.0
二、在my.cnf中加入authentication_policy= mysql_native_password

# Custom config should go here
!includedir /etc/mysql/conf.d/

authentication_policy= mysql_native_password

三、更改之前用户使用的认证插件

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';

四、查看用户认证插件

mysql> select host,user,plugin from user;
+-----------+------------------+-----------------------+
| host      | user             | plugin                |
+-----------+------------------+-----------------------+
| %         | root             | mysql_native_password |
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session    | caching_sha2_password |
| localhost | mysql.sys        | caching_sha2_password |
| localhost | root             | caching_sha2_password |
+-----------+------------------+-----------------------+