在开发过程中,由于对不同的数据表进行操作,结果提示:Error updating database. Cause: java.sql.SQLSyntaxErrorException: INSERT command denied to user 'manager'@'localhost' for table 't_pa_exclusive_group' ### The error may exist

详细错误提示

### Error updating database. Cause: java.sql.SQLSyntaxErrorException: INSERT command denied to user 'manager'@'localhost' for table 't_pa_exclusive_group' ### The error may exist in cn/custom/admin/dubboservice/batch/exclusivegroup/dal/mapper/ExclusivegroupMapper.java (best guess) ### The error may involve cn.custom.admin.dubboservice.batch.exclusivegroup.dal.mapper.ExclusivegroupMapper.insert-Inline ### The error occurred while setting parameters ### SQL: INSERT INTO custom.t_pa_exclusive_group ( dev_merchid, ex_merchid, ex_merchname, dev_groupid, create_time ) VALUES ( ?, ?, ?, ?, ? ) ### Cause: java.sql.SQLSyntaxErrorException: INSERT command denied to user 'manager'@'localhost' for table 't_pa_exclusive_group' ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: INSERT command denied to user 'manager'@'localhost' for table 't_pa_exclusive_group'

原因是因为权限问题,因为是由不同的用户名来操作其它数据库的,解决方法是给当前的用户名给添加上其它数据库的相当权限