Configuring a MySQL for Confluence

Confluence permits you to create, store, work together on, and share work with your group and other groups, similar to user or the overall public, if and when you have to. It’s a centralized place where you can cooperate on projects that matter to you and your buddies.

This page gives guidelines to configuring Confluence to use the MySQL database.

Step 1: Install the MySQL database driver

If you are installing Confluence, we require MySQL Connector driver. You can download either the .tar.gz or the .zip file by selecting the ‘Platform Independent’ option. Download latest recommended MySQL Connector driver from official site:
Either you can download using following command:

# cd /opt
# wget http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.35.tar.gz

Extract the archive file using following command:

# tar -zxvf mysql-connector-java-5.1.35.tar.gz

Copy the JAR file into the lib folder of your Confluence installation:

# cd /opt/mysql-connector-java-5.1.35
# cp mysql-connector-java-5.1.35-bin.jar /confluence/WEB-INF/lib

Step 2: Install the MySQL database driver

In this step you will make a database inside MySQL to hold your Confluence information, and a database user with authority to get to that database. Run following command to create new database and user privileges;

# mysql -u root -p
# mysql> CREATE DATABASE confluence CHARACTER SET utf8 COLLATE utf8_bin;
# mysql> GRANT ALL PRIVILEGES ON confluence.* TO 'confluenceuser'@'localhost' IDENTIFIED BY 'confluencepass';

Step 3: Restart Tomcat

Run following command to bring Tomcat up while you are making these changes.

# cd <CONFLUENCE_INSTALLATION>/bin
# ./shutdown.sh
# ./startup.sh