Getting error during installation of bitbucket server
Bitbucket version: 6.10.0
MySQL version: 8.0.17
OS: CentOS Linux 8 (Core) Kernel: Linux 4.18.0-147.el8.x86_64
Error: The schema could not be created.
The schema could not be created. com.atlassian.stash.internal.db.DefaultDatabaseManager.createSchema(DefaultDatabaseManager.java:341) com.atlassian.stash.internal.db.DefaultDatabaseManager.prepareDatabase(DefaultDatabaseManager.java:191) com.atlassian.stash.internal.maintenance.SpringMaintenanceTaskFactory.setupTask(SpringMaintenanceTaskFactory.java:151) ... Error creating bean with name 'liquibasePrototype' defined in class path resource [stash-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set com/atlassian/caviar/db/changelog/r1_0/initial-schema.xml::initial-schema-03::mheemskerk: Reason: liquibase.exception.DatabaseException: REFERENCES command denied to user 'bitbucketuser'@'192.168.123.55' for table 'bitbucket.cwd_application' [Failed SQL: CREATE TABLE bitbucket.cwd_app_dir_mapping (id BIGINT NOT NULL, application_id BIGINT NOT NULL, directory_id BIGINT NOT NULL, allow_all CHARACTER(255) NOT NULL, list_index INT NULL, CONSTRAINT SYS_PK_10077 PRIMARY KEY (id), CONSTRAINT FK_APP_DIR_APP FOREIGN KEY (application_id) REFERENCES bitbucket.cwd_application(id), CONSTRAINT FK_APP_DIR_DIR FOREIGN KEY (directory_id) REFERENCES bitbucket.cwd_directory(id))] org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1778) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515) ... Migration failed for change set com/atlassian/caviar/db/changelog/r1_0/initial-schema.xml::initial-schema-03::mheemskerk: Reason: liquibase.exception.DatabaseException: REFERENCES command denied to user 'bitbucketuser'@'192.168.123.55' for table 'bitbucket.cwd_application' [Failed SQL: CREATE TABLE bitbucket.cwd_app_dir_mapping (id BIGINT NOT NULL, application_id BIGINT NOT NULL, directory_id BIGINT NOT NULL, allow_all CHARACTER(255) NOT NULL, list_index INT NULL, CONSTRAINT SYS_PK_10077 PRIMARY KEY (id), CONSTRAINT FK_APP_DIR_APP FOREIGN KEY (application_id) REFERENCES bitbucket.cwd_application(id), CONSTRAINT FK_APP_DIR_DIR FOREIGN KEY (directory_id) REFERENCES bitbucket.cwd_directory(id))] liquibase.changelog.ChangeSet.execute(ChangeSet.java:637) liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53) liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:78) ... REFERENCES command denied to user 'bitbucketuser'@'192.168.123.55' for table 'bitbucket.cwd_application' [Failed SQL: CREATE TABLE bitbucket.cwd_app_dir_mapping (id BIGINT NOT NULL, application_id BIGINT NOT NULL, directory_id BIGINT NOT NULL, allow_all CHARACTER(255) NOT NULL, list_index INT NULL, CONSTRAINT SYS_PK_10077 PRIMARY KEY (id), CONSTRAINT FK_APP_DIR_APP FOREIGN KEY (application_id) REFERENCES bitbucket.cwd_application(id), CONSTRAINT FK_APP_DIR_DIR FOREIGN KEY (directory_id) REFERENCES bitbucket.cwd_directory(id))] liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356) liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57) liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125) ... REFERENCES command denied to user 'bitbucketuser'@'192.168.123.55' for table 'bitbucket.cwd_application' com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ...