#install server
sudo apt-get install mysql-server
#check server
sudo netstat -tap | grep mysql
#install client
sudo apt-get install mysql-client
#install Java driver
sudo apt-get install libmysql-java
#install mysql tool
sudo apt-get install mysql-admin phpmyadmin mysql-query-browser
#Change the default of encoding to UTF8
sudo nano /etc/mysql/myc.nf
>>[client]
>>default-character-set=utf8
>>[mysqld]
>>default-character-set=utf8
sudo service mysql restart
#Create database table/user for alfresco
sudo mysql -h localhost -u root -p
mysql> CREATE DATABASE alfresco DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
mysql> GRANT ALL PRIVILEGES ON alfresco.* TO alfresco@localhost IDENTIFIED BY ‘alfresco’;
mysql> GRANT SELECT,LOCK TABLES ON alfresco.* TO alfresco@localhost IDENTIFIED BY ‘alfresco’;
mysql> FLUSH PRIVILEGES;
mysql> quit;
Install Sun Java & configed as default
sudo add-apt-repository deb http://archive.canonical.com/ubuntu maverick partner sudo add-apt-repository deb-src http://archive.canonical.com/ubuntu maverick partner sudo apt-get update sudo apt-get install sun-java6-jre sun-java6-bin sun-java6-jdk
sudo update-alternatives --config java
export JAVA_HOME=
# Install alfresco with advanced configuration, without Java,PostgreSql, OpenOffice
# with parameter
jdbc:mysql://localhost/alfresco?useUnicode=yes&characterEncoding=UTF-8
com.mysql.jdbc.Driver
sudo ./alfresco-community-3.4.e-installer-linux-x64.bin
#Install the MySQL database connector
The MySQL database connector is required when installing Alfresco with MySQL. The database connector allows MySQL database to talk to the Alfresco server.
- Browse to the MySQL download site: http://dev.mysql.com/
- Download MySQL Connector/J x.x, and extract the following file from the downloaded .zip or .tar.gz file:
mysql-connector-java-5.x.x-bin.jar
- Copy the JAR file into the <TOMCAT_HOME>/lib directory for Tomcat 6.
# Launch Alfresco
sudo ./alfresco.sh start