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

Cannot install jira 8.20.1 on mysql 8.0.26

Hello, I working on to install Jira 8.20.1 and Mysql 8.0.26 but I have always the same error:

You have specified a database that is not empty, please specify an empty database. If you want to upgrade an existing installation, please follow these instructions instead.

I have make an new empty database but constants the same error what do I wrong?

3 answers

1 vote
Dirk Ronsmans Community Leader Dec 02, 2021

Did you maybe after the upgrade copy over your dbconfig.xml ? It looks like your config file is pointing to a previously created db.

Have you checked the DB you are pointing to to see if it really is empty?

No this is a new installation

Dirk Ronsmans Community Leader Dec 02, 2021

On a new installation you should be able to point it to the correct DB during the initialization. 

I assume that is where you get the error? 

Are you sure you are point to the correct DB then? I'd say just verify the DB you are trying to connect to first..

Since it says it's not empty it can connect..

The Mysql server is on the same Linux server as Jira is installed.

Dirk Ronsmans Community Leader Dec 02, 2021

Well only thing I can suggest is to really use something like a Mysql workbench and truely check if any tables exist already. 

If so, drop them.

I have in mysql : drop database jiradb; and then I create database jiradb.

CREATE DATABASE jiradb CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

 

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on <JIRADB>.* TO '<USERNAME>'@'<JIRA_SERVER_HOSTNAME>';

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| jiradb |
| mysql |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.00 sec)

mysql> use jiradb;
Database changed
mysql> show tables;
Empty set (0.00 sec)

mysql>

Is there progress on this?

Dirk Ronsmans Community Leader Dec 03, 2021

Not really sure what this could be since you don't have any tables.

I'd say open a ticket with Atlassian directly (https://support.atlassian.com/contact) and see if this is a known bug?

When I set the credentials for the database and click op "Test Connection" then...

Oh, I have copyed the mysql-connector-java-8.0.26.jar driver to /opt/atlassian/jira/lib/

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

How we use Jira Service Management for our recruitment process! - Part 2

It is never about setting up a process and being done with it. Rather, the focus should always be on optimizing it for the best outcomes. Thus, we didn’t stop at setting up JSM for our recruitment pr...

194 views 0 5
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