Database Setup

IMPORTANT: Zanata's wiki has moved to https://github.com/zanata/zanata-platform/wiki

New link: https://github.com/zanata/zanata-platform/wiki/Database-Setup

---

Zanata has been thoroughly tested against MySQL 5.5 and the Zanata team therefore recommends that you install and use this version with Zanata. Zanata is known to work with with MariaDB however.

Install MySQL

1. Install MySQL client - yum install mysql
2. Install MySQL server - yum install mysql-server
3. Run mysql_secure_installation for initial setup

JDBC Driver

• You will need to install the MySql JDBC driver, Connector/J into JBoss AS.

• Download it from http://www.mysql.com/products/connector/j/

• Then, untar/unzip it and extract the jar file.

• Copy the jar file into $JBOSS_HOME/standalone/deployments.

  Or

• Download through Maven. Jar file will be in ~/.m2/repository/mysql/mysql-connector-java/5.1.9/mysql-connector-java-5.1.9.jar

  Or

• run yum install mysql-connector-java.

• create shortcut sudo ln -sf /usr/share/java/mysql-connector-java.jar $JBOSS_HOME/standalone/deployments/mysql-connector-java.jar

Setup for Zanata

• Create a database in MySQL, named zanata, make sure it's UTF8. CREATE DATABASE zanata /*!40100 DEFAULT CHARACTER SET utf8 */;

• Start the MySQL database by running /etc/init.d/mysqld start from the command line