解决 Access denied for user ‘刘å°�å…°‘@‘localhost‘ (using password: YES)

背景：spring整合mybatis时，数据库配置和spring配置分开配置如下

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/smbms?useSSL=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=CST
username=root
password=123

 

 

 

spring引用如下：

<!--关联数据库配置文件-->
<context:property-placeholder location="classpath:datebase.properties"/>
<!--数据连接池配置-->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
     <property name="driverClass" value="${driver}"/>
    <property name="jdbcUrl" value="${url}"/>
    <property name="user" value="${username}"/>
    <property name="password" value="${password}"/>

 

对数据库操作时报错

Access denied for user '刘�兰'@'localhost' (using password: YES)

解决：

将database.properties中修改

jdbc.username=root

<property name="user" value="${jdbc.username}"/>

结果操作数据库正常