Install Alfresco with Mysql on Ubuntu

#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