How to install MySQL for Confluence (on the same Windows Server)

Linda Meier

Hello, 

I'm currently trying to install a MySQL Database for Confluence. 

I have never worked with MySQL before. 

 

I'm trying to install MySQL and Confluence on the same Server, a Windows 2012 R2. 

I used these guides:

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

https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html

 

I downloaded a version of MySQL called '(mysql-installer-community-5.7.24.0.msi)' from the official website. 

[I tried a zip archive called '(mysql-5.7.24-winx64.zip)' first but I did not know what to do with it or how to install it - seeing as I couldn't find the files I seemed to need to install it.]

 

So, I went through the installation, but:

None of the things I have to configurate are there. 

The Atlassian database setup guide expects me to check things I can't choose - 

like 'Transactional Database Only' which I haven't seen in the whole installation procedure, or 'InnoDB' which you can choose, but only for testing purposes. 

 

Also, something like 'Reconfigure Instance' does not exist. 

I just choose the things which seemed best but now I have an DB I can't do much with. 

 

How does this work? Which MySQL Installation do I need?

I choose a supported MySQL version but the documentation is completely different?

 

Thanks in advance.

JP _AC Bielefeld Leader_

Hi,

before installing Confluence you should put your efforts on installing & running the MySQL server. You chose the right version, but it might be easier to install MySQL by using the installer version:

https://dev.mysql.com/downloads/windows/installer/5.7.html

You should then proceed with:

https://dev.mysql.com/doc/refman/5.7/en/mysql-installer.html

* Install MySQL server as a service

If you want to stay with the zip version, proceed with:

https://dev.mysql.com/doc/refman/5.7/en/windows-install-archive.html

Make sure you install a MySQL User Interface, like MySQL Workbench or HeidiSQL. Both will ease your tasks like creating a database for Confluence later on. InnoDB is the only relevant database engine used by MySQL by now. It should be use by default & is transactional by default.

So, when your MySQL server is set up, try to connect to it, either using the command line tool mysql or the MySQL Workbench or a similar tool. You can then proceed with the Confluence specific installation in 

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

Start here with 2. Edit the my.cnf (my.ini on Windows operating system)

I assume you know how to identify & find the my.ini file on a windows operating system. It should be located in the MySQL installation directory.

You can execute the SQL commands for creating & setting up the database using the Workbench, if you prefer.

Make sure, that the character set & collation value are correct. Confluence will check when connecting to the MySQL server & database if these settings are correct. You cannot proceed with the Confluence installation until the setting match.

Best of luck,

JP