Liferay 6.0.6 GlassFish Bundle: MySQL Database Configuration

1) Using 7-zip program, extract the content of liferay-portal-glassfish-6.0.6-20110225.zip\liferay-portal-6.0.6 to C:\Z\lifeglass2
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 Glassfish Server.
Run Command Prompt
Type: cd C:\Z\lifeglass2\glassfish-3.0.1\bin (refer Step 1 above).
Type: asadmin start-domain

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