When trying to connect bitbucket to mysql, it fails with the following warning:
"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."
However, when logging into the database with the bitbucket user, a temporary table can be created without error:
root@mysqlatlassian:/var/db/mysql # mysql -ubitbucket -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2875
Server version: 5.7.23-log Source distribution
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
bitbucket@localhost [(none)]> use bitbucket;
Database changed
bitbucket@localhost [bitbucket]> create temporary table test123 (testid int);
Query OK, 0 rows affected (0.00 sec)
bitbucket@localhost [bitbucket]> drop temporary table test123;
Query OK, 0 rows affected (0.01 sec)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.