Bitbucket database migration to MySQL 5.7 failed

Muhamed Buzaljko

Message:

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.

I checked everything and all permissions are properly granted to the user.

My Bitbucket is currently running on MySQL v 5.6.x

MySQL Version 5.7.23

Bitbucket version 6.1.3 (But I tried with all previous versions as well)

Ana Retamal

Hi Muhamed,

First of all, please note that according to our documentation, while MySQL is supported by Bitbucket Server, is currently not recommended. In addition to this, you should not use Bitbucket Server with the following:

• MySQL 5.6.15 and earlier: due to bugs in its query optimizer (#68424, #69005). See Connecting Bitbucket Server to MySQL for more information.
• MySQL 5.7.0 - 5.7.8

Since you indicated that you're using 5.7.23, my recommendation is for you to upgrade MySQL, or change to a different database if possible.

Once the database is set to a supported one, please double check that the permissions are correctly set as explained at Config properties - Database.

For more information, you can also read Connecting Bitbucket Server to MySQL.

Hope that helps!

Ana