ssm项目，Druid数据库链接报错errorCode 1045, state 28000

Question

问题：SSM项目，部署到服务器上，运行一段时间后总是会如下报错，导致查询不了

环境：阿里云服务器，权限和密码是没错的了，因为刚开始运行的时候，都可以正常显示的。百度很多照搬的教程都是说用户名错误一大堆，都没用。都是有jdbc前缀，也没有空格

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/wzqproduct?characterEncoding=utf-8&serverTimeZone=GMT
jdbc.username=root
jdbc.password=root

报错异常代码

2022-09-17 14:59:45 下午 [Thread: Druid-ConnectionPool-Create-1464010809][ Class:com.alibaba.druid.pool.DruidDataSource >> Method: com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2181) ]

ERROR:create connection error, url: jdbc:mysql://localhost:3306/wzqproduct?characterEncoding=utf-8, errorCode 1045, state 28000
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
    at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2205)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2236)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2035)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:790)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
    at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:148)
    at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:217)
    at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:142)
    at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1466)
    at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1529)
    at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2178)

后台代码

 //查询商品所有分类
    @RequestMapping("/categorylist")
    @ResponseBody
    public List<Category> selectCategoryList() {
        Jedis jedis = null;
        List<Category> cs = null;
        Set<Tuple> categorys = null;
         //防止Redis服务出现问题，这里try一下
        try {
            jedis = JedisUtil.getJedis();
            categorys = jedis.zrangeWithScores("category", 0, -1);
        }catch (Exception e){
            logger.error("redis服务器异常报错："+e);
        }
            cs = productService.selectCategoryList();

            if (categorys == null || categorys.size() == 0) {
                //如果redis为空，从数据库中查询
                cs = productService.selectCategoryList();
                //把数据，存入redis中
                if (jedis != null) {
                    for (int i = 0; i < cs.size(); i++) {
                        jedis.zadd("category", cs.get(i).getId(), cs.get(i).getName());
                    }
                }
            } else {
                //把redis的set集合，转为list集合
                cs = new ArrayList<Category>();
                for (Tuple tuple : categorys) {
                    Category category = new Category();
                    category.setName(tuple.getElement());
                    category.setId((int) tuple.getScore());
                    cs.add(category);
                }
            }
        return cs;
    }

连接池代码

    <!-- 数据库连接池 -->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
        destroy-method="close">
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
        <property name="driverClassName" value="${jdbc.driver}" />
        <!-- 最大并发连接数 -->
        <property name="maxActive" value="30" />
        <!-- 最小空闲连接数 -->
        <property name="minIdle" value="5" />
        <!-- 用于显示数据源监控中的sql语句监控 -->
        <property name="filters" value="stat" />
    </bean>

Answer 1

部署到服务器，将jdbc的ip地址用正式ip来替代是不是可以？不要用127.0.0.1或者localhost，试试能不能解决你的问题。