nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I set up Concluence to use our MySQL database? Instructions seem to be missing info.

Steven Vervais

I'm following the instructions on

Ref:

https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html

which says

2. Configure MySQL Server

"Note: If you intend to connect Confluence to an existing MySQL database server, we strongly recommend that you reconfigure this database server by running through the configuration steps in the MySQL installation wizard as described below.

"To configure MySQL Server:

Run the MySQL installation wizard:
If you are connecting Confluence to your existing MySQL server, choose Reconfigure Instance."

When I installed MySQL 8, folowing the links and instructions in Ref, it never gave me an opportunity to do all the choices required by Ref, and now I am stuck at this page, unable to succeed with Test connection, or even to know what to put in the several blanks:
http://localhost:8090/setup/setupdbtype-start.action

I tried various possibilities, but all fail with something like

SQLState - 28000
Error Code - 1698
java.sql.SQLException: Access denied for user 'root'@'localhost'

I tried to learn how to re-start the MySQL installer, as recommended on several pages in the MySQL 8 Reference Manual, and nowhere do I find a specific command to do so. Likewise I see no opportunity to "choose Reconfigure Instance" as instructed in Ref.

Accepted answers

All comments

Francesc Arbó_vz84yd

Hi @Steven Vervais,

when you say you have installed MySQL 8 what do you mean? According to Atlassian, Confluence supports versions MySQL 5.6 and MySQL 5.7.

James Harris_xjm320

I’m Jim Harris, the lead for IT Infrastructure at Steve’s org. I am the one doing all the work on this setup of Atlassian products on our Ubuntu 18.04 server.

Per the original post in this thread, I followed the instructions in Ref, which led me to MySQL 8. This is a recent change.

Steven Vervais

This is Jim again.

On searching further, given your additional info to use for keywords, I see probably what you refer to:

https://confluence.atlassian.com/doc/supported-platforms-207488198.html

says MySQL 5.6 or 5.7.

I hope the Confluence setup instructions

https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html

can be improved by adding a link early on that page (I hope I didn't miss it) to refer to the current supported platforms page.

But now I still have the problems of not knowing how to:

(1) completely remove the wrong MySQL, and

(2) install the correct one, and

(3) find the option to "choose Reconfigure Instance" as instructed in Ref.

I will keep digging, but if anyone knows where those instructions are, I would appreciate a link.

Steven Vervais

OK, for several hours now I have descended into MySQL and PostgreSQL hell. I have found and followed the instructions to remove MySQL 8 (which seem to have worked) and install MySQL 5.7 (which fails with a missing dependency on mysql-community which I cannot resolve by installing same), and I cannot find any way to install PostgresQL 9.6 (or 9.5, ...) on Ubuntu 18.04; all attempts only install PostgreSQL 10.

I have searched, found, and followed several different methods, all of which fail.

Come on, Atlassian, _please_ give us some MySQL _and_ PostgreSQL installation and configuration instructions that _actually_work_ to allow continuing installation of Confluence.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

mysql