has no permission to run query,

此错误需要数据库管理员能给开启表的创建、删除等权限

•  
•  
• Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userMapper' defined in URL [jar:file:/export/Packages/yao-activity/20210305154631/WEB-INF/lib/yao-activity-dao-1.0-SNAPSHOT.jar!/com/jd/yao/activity/dao/mapper/UserMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/baomidou/mybatisplus/autoconfigure/MybatisPlusAutoConfiguration.class]: Unsatisfied dependency expressed through method 'sqlSessionFactory' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [com/baomidou/dynamic/datasource/spring/boot/autoconfigure/DynamicDataSourceAutoConfiguration.class]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerInvoker': Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #1 of class path resource [sql/schema/user.sql]: CREATE TABLE IF NOT EXISTS `user` ( `id` bigint(20) NOT NULL, `name` varchar(255) default NULL, `age` int(8) default NULL, `yn` tinyint(4) default NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB AUTO_INCREMENT=100001 DEFAULT CHARSET = utf8; nested exception is java.sql.SQLException: user yao_activity_rw has no permission to run query, sql: CREATE TABLE IF NOT EXISTS `user` ( `id` bigint(20) NOT NULL, `name` varchar(255) default NULL, `age` int(8) default NULL, `yn` tinyint(4) default NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB AUTO_INCREMENT=100001 DEFAULT CHARSET = utf8
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1499)
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1379)
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:592)
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
• at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
• at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
• at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
• at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.resolveBeanByName(AbstractAutowireCapableBeanFactory.java:452)
• at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:526)
• at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:496)
• at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:636)
• at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:180)
• at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:90)
• at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessProperties(CommonAnnotationBeanPostProcessor.java:321)
• ... 30 more
• Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/baomidou/mybatisplus/autoconfigure/MybatisPlusAutoConfiguration.class]: Unsatisfied dependency expressed through method 'sqlSessionFactory' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [com/baomidou/dynamic/datasource/spring/boot/autoconfigure/DynamicDataSourceAutoConfiguration.class]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerInvoker': Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #1 of class path resource [sql/schema/user.sql]: CREATE TABLE IF NOT EXISTS `user` ( `id` bigint(20) NOT NULL, `name` varchar(255) default NULL, `age` int(8) default NULL, `yn` tinyint(4) default NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB AUTO_INCREMENT=100001 DEFAULT CHARSET = utf8; nested exception is java.sql.SQLException: user yao_activity_rw has no permission to run query, sql: CREATE TABLE IF NOT EXISTS `user` ( `id` bigint(20) NOT NULL, `name` varchar(255) default NULL, `age` int(8) default NULL, `yn` tinyint(4) default NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB AUTO_INCREMENT=100001 DEFAULT CHARSET = utf8
• at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:769)
• at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:509)
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1305)
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1144)
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
• at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
• at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
• at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
• at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
• at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:277)
• at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1247)
• at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1167)
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1484)
• ... 44 more
• Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [com/baomidou/dynamic/datasource/spring/boot/autoconfigure/DynamicDataSourceAutoConfiguration.class]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerInvoker': Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #1 of class path resource [sql/schema/user.sql]: CREATE TABLE IF NOT EXISTS `user` ( `id` bigint(20) NOT NULL, `name` varchar(255) default NULL, `age` int(8) default NULL, `yn` tinyint(4) default NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB AUTO_INCREMENT=100001 DEFAULT CHARSET = utf8; nested exception is java.sql.SQLException: user yao_activity_rw has no permission to run query, sql: CREATE TABLE IF NOT EXISTS `user` ( `id` bigint(20) NOT NULL, `name` varchar(255) default NULL, `age` int(8) default NULL, `yn` tinyint(4) default NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB AUTO_INCREMENT=100001 DEFAULT CHARSET = utf8
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:601)
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
• at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
• at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
• at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
• at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
• at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:277)
• at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1247)
• at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1167)
• at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:857)
• at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:760)
• ... 57 more
• Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerInvoker': Invocation of init method failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #1 of class path resource [sql/schema/user.sql]: CREATE TABLE IF NOT EXISTS `user` ( `id` bigint(20) NOT NULL, `name` varchar(255) default NULL, `age` int(8) default NULL, `yn` tinyint(4) default NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB AUTO_INCREMENT=100001 DEFAULT CHARSET = utf8; nested exception is java.sql.SQLException: user yao_activity_rw has no permission to run query, sql: CREATE TABLE IF NOT EXISTS `user` ( `id` bigint(20) NOT NULL, `name` varchar(255) default NULL, `age` int(8) default NULL, `yn` tinyint(4) default NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB AUTO_INCREMENT=100001 DEFAULT CHARSET = utf8
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1762)
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593)
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
• at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
• at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
• at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
• at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:224)
• at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1115)
• at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveBean(DefaultListableBeanFactory.java:407)
• at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBean(DefaultListableBeanFactory.java:341)
• at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBean(DefaultListableBeanFactory.java:335)
• at org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerPostProcessor.postProcessAfterInitialization(DataSourceInitializerPostProcessor.java:55)
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:429)
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1766)
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593)
• ... 67 more
• Caused by: org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #1 of class path resource [sql/schema/user.sql]: CREATE TABLE IF NOT EXISTS `user` ( `id` bigint(20) NOT NULL, `name` varchar(255) default NULL, `age` int(8) default NULL, `yn` tinyint(4) default NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB AUTO_INCREMENT=100001 DEFAULT CHARSET = utf8; nested exception is java.sql.SQLException: user yao_activity_rw has no permission to run query, sql: CREATE TABLE IF NOT EXISTS `user` ( `id` bigint(20) NOT NULL, `name` varchar(255) default NULL, `age` int(8) default NULL, `yn` tinyint(4) default NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB AUTO_INCREMENT=100001 DEFAULT CHARSET = utf8
• at org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:509)
• at org.springframework.jdbc.datasource.init.ResourceDatabasePopulator.populate(ResourceDatabasePopulator.java:238)
• at org.springframework.jdbc.datasource.init.DatabasePopulatorUtils.execute(DatabasePopulatorUtils.java:48)
• at org.springframework.boot.autoconfigure.jdbc.DataSourceInitializer.runScripts(DataSourceInitializer.java:210)
• at org.springframework.boot.autoconfigure.jdbc.DataSourceInitializer.createSchema(DataSourceInitializer.java:104)
• at org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerInvoker.afterPropertiesSet(DataSourceInitializerInvoker.java:64)
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1821)
• at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1758)
• ... 81 more
• Caused by: java.sql.SQLException: user yao_activity_rw has no permission to run query, sql: CREATE TABLE IF NOT EXISTS `user` ( `id` bigint(20) NOT NULL, `name` varchar(255) default NULL, `age` int(8) default NULL, `yn` tinyint(4) default NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB AUTO_INCREMENT=100001 DEFAULT CHARSET = utf8
• at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
• at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
• at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
• at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:782)
• at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:666)
• at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:3010)
• at com.alibaba.druid.wall.WallFilter.statement_execute(WallFilter.java:422)
• at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:3008)
• at com.alibaba.druid.filter.FilterAdapter.statement_execute(FilterAdapter.java:2484)
• at com.alibaba.druid.filter.FilterEventAdapter.statement_execute(FilterEventAdapter.java:188)
• at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:3008)
• at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.execute(StatementProxyImpl.java:147)
• at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:633)
• at com.jd.home.framework.monitor.db.jdbc.statement.AbstractMonitorStatement.execute(AbstractMonitorStatement.java:97)
• at org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:488)
• ... 88 more