Bitbucket connects to mysql for error

Junyang Zhang April 13, 2018
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) ...

1 answer

0 votes
Alexis Robert
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 13, 2018

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

Saravana Kumar September 17, 2019

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

KAN ADMIN September 30, 2019

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?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events