Bitbucket connects to mysql for error

Question

Bitbucket does not have adequate permissions to create a temporary table in the target database when connected as the specified user. Please check that the user has permission to CREATE TEMPORARY TABLES. For information about creating a database for use with Bitbucket, please refer to the Bitbucket documentation. If you continue having issues, get in touch with our support team and we'll help get you up and running. Hide details Bitbucket does not have adequate permissions to create a temporary table in the target database when connected as the specified user. Please check that the user has permission to CREATE TEMPORARY TABLES. For information about creating a database for use with Bitbucket, please refer to the Bitbucket documentation. com.atlassian.stash.internal.db.DefaultDatabaseManager.validateConfiguration(DefaultDatabaseManager.java:226) com.atlassian.stash.internal.migration.DefaultMigrationService.validateConfiguration(DefaultMigrationService.java:85) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ...

KAN ADMIN · Answer

We're also running into the same issue trying to port our database to the GCP SQL instance, same exact version and problem as you're encountering.  Anyone have any solutions?

Saravana Kumar_0n7961 · Answer

Hi Alexis,

I am also facing the same issue on GCP - CloudSQL (MySQL5.6). Even i tried to apply  "GRANT CREATE TEMPORARY TABLES" on Bitbucket DB user still getting the same error.

Note: Bitbucket server installed Centos 7 on GCP CE instance.

MySQL Driver - mysql-connector-java-5.1.47-bin.jar

Please advise.

Regards

Saravana

Alexis Robert · Answer

Hello,

you need to grant the proper permissions to the user specified in bitbucket database configuration.

You will have to do "GRANT CREATE TEMPORARY TABLES" on your MySQL instance.

Cheers,

-- Alexis