Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Bitbucket connects to mysql for error

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 Apr 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

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

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
Community showcase
Published in Bitbucket

Powering DevOps with Bitbucket Server & Data Center

Hi everyone, The Cloud team recently announced 12 new DevOps features that help developers ship better code, faster   ! While we’re all excited about the new improvements to Bitbucket ...

1,886 views 0 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you