SSH Exception 2017.3.27-2 java.sql.SQLException: Access denied for user 'root'@'localhost'

连数据库时报错：

java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

1.把密码在这配置：

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
         <property name="driverClass" value="${jdbc.driverClass}"/>
         <property name="jdbcUrl" value="${jdbc.url}"/>
         <property name="user" value="${jdbc.username}"/>
         <property name="password" value="${jdbc.password"/>
</bean>

<property name="hibernateProperties">
                   <props>
                       <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
                       <prop key="hibernate.show_sql">true</prop>
                       <prop key="hibernate.format_sql">true</prop>
                       <prop key="hibernate.hbm2ddl.auto">update</prop>                
                   </props>
               </property>

换成在这配置就行了：

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
               <property name="driverClass" value="${jdbc.driverClass}"/>
               <property name="jdbcUrl" value="${jdbc.url}"/>
               <!-- <property name="user" value="${jdbc.username}"/>
               <property name="password" value="${jdbc.password"/> -->

</bean>

<property name="hibernateProperties">
                   <props>
                       <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
                       <prop key="hibernate.show_sql">true</prop>
                       <prop key="hibernate.format_sql">true</prop>
                       <prop key="hibernate.hbm2ddl.auto">update</prop>
                       <prop key="hibernate.connection.username">root</prop>
                    <prop key="hibernate.connection.password">root</prop>
                   </props>
               </property>

2.可能由于root的权限不够，可以进行如下操作

1)      以root进入mysql

2)      赋予root权限：

mysql> GRANTALL PRIVILEGES ON *.* TO 'root'@'localhost'

->     IDENTIFIEDBY 'some_pass' WITH GRANT OPTION; 

//本地操作的权限

mysql> GRANTALL PRIVILEGES ON *.* TO ' root '@'%'

->     IDENTIFIEDBY 'some_pass' WITH GRANT OPTION;

                    //远程操作的权限