表'performance_schema.session_variables'不存在 [英] Table 'performance_schema.session_variables' doesn't exist
问题描述
我是使用MySql数据库的新手,我已经下载了EasyPHP-Devserver-16.1,当我运行服务器以更新数据库模式时,此错误消息就会出现.
I m new at using MySql data base, i have downloaded EasyPHP-Devserver-16.1, when I run my server to update my data base schema this error message shows up.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:表 'performance_schema.session_variables'不存在
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'performance_schema.session_variables' doesn't exist
我知道问题不在我的spring配置文件中,而是在mysql服务器中.
I know that the problem is not in my spring configuration file but in mysql server.
public class Configurations {
protected static final String PROPERTY_NAME_DATABASE_DRIVER = "com.mysql.jdbc.Driver";
protected static final String PROPERTY_NAME_DATABASE_PASSWORD = "";
protected static final String PROPERTY_NAME_DATABASE_URL = "jdbc:mysql://127.0.0.1:3306/quraa";
protected static final String PROPERTY_NAME_DATABASE_USERNAME = "root";
private static final String PROPERTY_PACKAGES_TO_SCAN = "com.med.quraa.models";
@Bean
public LocalContainerEntityManagerFactoryBean entityManagerFactoryBean(DataSource dataSource, JpaVendorAdapter jpaVendorAdapter){
LocalContainerEntityManagerFactoryBean entityManagerFactoryBean = new LocalContainerEntityManagerFactoryBean();
entityManagerFactoryBean.setDataSource(dataSource);
entityManagerFactoryBean.setJpaVendorAdapter(jpaVendorAdapter);
entityManagerFactoryBean.setPackagesToScan(PROPERTY_PACKAGES_TO_SCAN);
return entityManagerFactoryBean;
}
@Bean
public DriverManagerDataSource dataSource(){
DriverManagerDataSource ds = new DriverManagerDataSource();
ds.setDriverClassName(PROPERTY_NAME_DATABASE_DRIVER);
ds.setUrl(PROPERTY_NAME_DATABASE_URL);
ds.setUsername(PROPERTY_NAME_DATABASE_USERNAME);
ds.setPassword(PROPERTY_NAME_DATABASE_PASSWORD);
return ds;
}
@Bean
public JdbcTemplate jdbcTemplate(){
JdbcTemplate jdbcTemplate=new JdbcTemplate();
jdbcTemplate.setDataSource(dataSource());
return jdbcTemplate;
}
@Bean
public JpaVendorAdapter jpaVendorAdapter(){
HibernateJpaVendorAdapter adapter = new HibernateJpaVendorAdapter();
adapter.setDatabase(Database.MYSQL);
adapter.setShowSql(true);
adapter.setGenerateDdl(true);
adapter.setDatabasePlatform("org.hibernate.dialect.MySQL5InnoDBDialect");
return adapter;
}
@Bean
public PlatformTransactionManager transactionManager(EntityManagerFactory entityManagerFactory) {
return new JpaTransactionManager(entityManagerFactory);
}
}
请注意,我也测试了org.apache.tomcat.dbcp.dbcp.BasicDataSource
,但是我遇到了相同的错误,这意味着org.springframework.jdbc.datasource.DriverManagerDataSource
对此没有问题
Note that I have tested org.apache.tomcat.dbcp.dbcp.BasicDataSource
also but I had the same error, that means that org.springframework.jdbc.datasource.DriverManagerDataSource
have no problem with that
推荐答案
已解决... 然后我打开了cmd:
Solved... I opened cmd then :
cd [installation_path]\eds-binaries\dbserver\mysql5711x86x160420141510\bin
然后执行此命令行:
mysql_upgrade -u root -p --force
需要重新启动服务器!
这篇关于表'performance_schema.session_variables'不存在的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!