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)
...