Liferay 6.0.6 Tomcat Bundle: MySQL Database Configuration

1) Using 7-zip program, extract the content of liferay-portal-tomcat-6.0.6-20110225.zip\liferay-portal-6.0.6 to C:\Z\lifetom2
Close 7-zip when you are done.

2) Using UwAmp program (download at http://www.uwamp.com/en/?page=download), run the Apache and MySQL Server. Click PHPMyAdmin button and create new database lportal, with UTF8 character set. By default, the username/password is root/root.


3) Using Notepad++, create a file [Liferay_Home]/portal-ext.properties with the following codes. (Hint: Liferay_Home is the directory in which the readme.html is located)
jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/lportal?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=root
jdbc.default.password=root



4) Start Tomcat Server.
Run Command Prompt
Type: cd C:\Z\lifetom2\tomcat-6.0.29\bin (refer Step 1 above).
Type: startup

5) Reload the PHPMyAdmin page to see that the lportal database is populated with 185 tables.