在SSM框架整合中其配置都没有语法错误却出现:Access denied for user ‘ASUS’@‘localhost’ (using password: YES)
- 一.在jdbc_info.properties的命名出错
<bean id="pooledDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="${driver}"/> <property name="url" value="${url}"/> <property name="username" value="${username}"/> <property name="password" value="${password}"/> </bean>
修改后:<bean id="pooledDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="${jdbc.driver}"/> <property name="url" value="${jdbc.url}"/> <property name="username" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}"/> </bean>
- 然后在.properties中配置中
加入jdbc
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/spring?useUnicode=true&characterEncoding=utf8
password=888888
username=root
改后的结果
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/spring?jdbc.useUnicode=true&characterEncoding=utf8
jdbc.password=888888
jdbc.username=root
原因:
username在windows下默认取值为电脑的账号,一般电脑账号为administrator,