Confluence change database port

[Sven Hüßner]

I need a secondary mysql database with an older version to run with the standard port (3306).

This means that I need to move the main mysql server from port 3306 to a different one (3307).

Confluence runs on this server. Thus I need to tell confluence to connect to the mysql server on 3307.

Nothing changes, databases don't even move. Only the port of the server changes.

How can i configure this in confluence?

Beste regards,

Sven

[Rodrigo Girardi Adami · Accepted solution]

Hi Sven,

To change the Confluence database listening ports, you can simply edit the Confluence.cfg.xml file located in confluence_home directory and add the port right after the database connection URL.

This should do the trick.

Cheers,

Rodrigo

[Sven Hüßner]

Perfect! Worked like a charm! For furture reference, this has to be changed: <property name="hibernate.connection.url">jdbc:mysql://localhost/confluence?sessionVariables=storage_engine%3DInnoDB</property> Simply put ":yourPortNumber" behind the "localhost": <property name="hibernate.connection.url">jdbc:mysql://localhost:<yourPortNumber>/confluence?sessionVariables=storage_engine%3DInnoDB</property> Thank you very much sir!

[Rodrigo Girardi Adami]

You are welcome Sven :) Glad I could help

[Nic Brough -Adaptavist-]

Yes, I was assuming that the poster knew how to work out a connection string. Anyway, Rodrigo beat me to the answer (and you usually find the string in the .cfg file will contain :3306 in it, which you just change to 3307)

[Sven Hüßner]

Forgot to mention that I have already found this article: https://answers.atlassian.com/questions/102583 But @Nic Brough [Adaptavist] did not mention the details of "Work[ing] out the new connection settings".