Liferay 6.0.6 GlassFish Bundle: MySQL Database Configuration Alternative 1

This is an alternative approach to http://setup-steps.blogspot.com/2013/07/liferay-606-glassfish-bundle-mysql.html


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\lifeglass2a
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 [Glassfish_Home]/domains/domain1/config with the following codes.
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\lifeglass2a\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.