我有以下代码。此代码负责从远程位置连接到MySQL数据库。但是问题是,代码正在尝试连接到本地主机上的MySQL。
实际收到的异常是:
引起原因:java.sql.SQLException:用户'my_user'@'localhost_ip'的访问被拒绝(使用密码:是)
我在项目中使用Spring,JPA和休眠模式。
@Configuration("persistenceContext")
@EnableJpaRepositories(entityManagerFactoryRef = "entityManagerFactory",
transactionManagerRef = "jpaTransactionManager",
basePackages = {"my.repository"})
@EnableTransactionManagement
public class PersistenceContext {
@Autowired
private DataSourcePropertyConfig dataSourcePropertyConfig;
public BasicDataSource datasource() {
final BasicDataSource dataSource = new BasicDataSource();
dataSource.setDriverClassName(dataSourcePropertyConfig.getMySqlDriverClassName());
dataSource.setUsername(dataSourcePropertyConfig.getMySqlDBUsername());
dataSource.setPassword(dataSourcePropertyConfig.getMySqlDBPassword());
dataSource.setUrl("jdbc:mysql://<host>:<port>/<database>");
dataSource.setMaxActive(10);
dataSource.setMaxIdle(5);
dataSource.setInitialSize(5);
dataSource.setValidationQuery("SELECT 1");
return dataSource;
}
public JpaVendorAdapter jpaVendorAdapter() {
final HibernateJpaVendorAdapter hibernateJpaVendorAdapter = new HibernateJpaVendorAdapter();
hibernateJpaVendorAdapter.setShowSql(true);
hibernateJpaVendorAdapter.setGenerateDdl(false);
hibernateJpaVendorAdapter.setDatabase(Database.MYSQL);
return hibernateJpaVendorAdapter;
}
@Bean(name = "entityManagerFactory")
public EntityManagerFactory entityManagerFactory() {
final LocalContainerEntityManagerFactoryBean entityManagerFactoryBean = new LocalContainerEntityManagerFactoryBean();
entityManagerFactoryBean.setDataSource(this.datasource());
entityManagerFactoryBean.setJpaVendorAdapter(this.jpaVendorAdapter());
entityManagerFactoryBean.setPackagesToScan("my.entity");
entityManagerFactoryBean.afterPropertiesSet();
return entityManagerFactoryBean.getObject();
}
@Bean(name = "jpaTransactionManager")
@Primary
public PlatformTransactionManager jpaTransactionManager() {
return new JpaTransactionManager(entityManagerFactory());
}
问候
阿努吉
最佳答案
错误讯息
用户'my_user'@'localhost_ip'的访问被拒绝(使用密码:是)
并不表示您正在使用本地主机的IP地址连接到数据库,而是表示您正在通过本地主机的IP地址进行连接。
关于为什么出现拒绝访问错误的原因:很可能您的数据库中没有与'my_user'@'localhost_ip'
或'my_user'@'%'
匹配的用户记录。
关于java - JPA-指向本地主机的EntityManagerFactory,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/45565625/