Liferay comes with a default database called HSQL or "hypersonic." This is not meant for production use however! You need to switch to a real database to use Liferay. In this section i will explain connection with MySql.
Follow the steps
1) Install MySql server in your sysstem
2)Open MySQL Command prompt and create a data base lportal
3)Go Inside liferay-portal-6.2.0-ce-ga1 folder and create a file by name portal- ext.properties
4) In Side portal-ext.properties write the following
# MySQL
#
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
5) Save it
6) Restart Server
6) Restart Server
Here lportal is data base name, you can create different data base and replace with lportal.
open MySQL Command Prompt run command
Enter password:root
mysql> use lportal
mysql>show tables;
+----------------------------------------+
| Tables_in_lportal |
+-----------------------------------------+
| account_ |
| address |
| announcementsdelivery |
| announcementsentry |
| announcementsflag |
| assetcategory |
| assetcategoryproperty |
| assetentries_assetcategories |
| assetentries_assettags |
| assetentry |
| assetlink |
| assettag |
| assettagproperty |
| assettagstats |
| assetvocabulary |
| blogsentry |
| blogsstatsuser |
| bookmarksentry |
| bookmarksfolder |
| browsertracker |
| calevent |
| classname_ |
| clustergroup |
| company |
| contact_ |
| counter |
| country |
| cyrususer |
| cyrusvirtual |
| ddlrecord |
| ddlrecordset |
| ddlrecordversion |
| ddmcontent |
| ddmstoragelink |
| ddmstructure |
| ddmstructurelink |
| ddmtemplate |
| dlcontent |
| dlfileentry |
| dlfileentrymetadata |
| dlfileentrytype |
| dlfileentrytypes_ddmstructures |
| dlfileentrytypes_dlfolders |
| dlfilerank |
| dlfileshortcut |
| dlfileversion |
| dlfolder |
| dlsync |
| emailaddress |
| expandocolumn |
| expandorow |
| expandotable |
| expandovalue |
| group_ |
| groups_orgs |
| groups_permissions |
| groups_roles |
| groups_usergroups |
| image |
| journalarticle |
| journalarticleimage |
| journalarticleresource |
| journalcontentsearch |
| journalfeed |
| journalstructure |
| journaltemplate |
| layout |
| layoutbranch |
| layoutprototype |
| layoutrevision |
| layoutset |
| layoutsetbranch |
| layoutsetprototype |
| listtype |
| lock_ |
| marketplace_app |
| marketplace_module |
| mbban |
| mbcategory |
| mbdiscussion |
| mbmailinglist |
| mbmessage |
| mbstatsuser |
| mbthread |
| mbthreadflag |
| mdraction |
| mdrrule |
| mdrrulegroup |
| mdrrulegroupinstance |
| membershiprequest |
| organization_ |
| orggrouppermission |
| orggrouprole |
| orglabor |
| passwordpolicy |
| passwordpolicyrel |
| passwordtracker |
| permission_ |
| phone |
| pluginsetting |
| pollschoice |
| pollsquestion |
| pollsvote |
| portalpreferences |
| portlet |
| portletitem |
| portletpreferences |
| quartz_blob_triggers |
| quartz_calendars |
| quartz_cron_triggers |
| quartz_fired_triggers |
| quartz_job_details |
| quartz_locks |
| quartz_paused_trigger_grps |
| quartz_scheduler_state |
| quartz_simple_triggers |
| quartz_simprop_triggers |
| quartz_triggers |
| ratingsentry |
| ratingsstats |
| region |
| release_ |
| repository |
| repositoryentry |
| resource_ |
| resourceaction |
| resourceblock |
| resourceblockpermission |
| resourcecode |
| resourcepermission |
| resourcetypepermission |
| role_ |
| roles_permissions |
| scframeworkversi_scproductvers |
| scframeworkversion |
| sclicense |
| sclicenses_scproductentries |
| scproductentry |
| scproductscreenshot |
| scproductversion |
| servicecomponent |
| shard |
| shoppingcart |
| shoppingcategory |
| shoppingcoupon |
| shoppingitem |
| shoppingitemfield |
| shoppingitemprice |
| shoppingorder |
| shoppingorderitem |
| socialactivity |
| socialactivityachievement |
| socialactivitycounter |
| socialactivitylimit |
| socialactivitysetting |
| socialrelation |
| socialrequest |
| subscription |
| team |
| ticket |
| user_ |
| usergroup |
| usergroupgrouprole |
| usergrouprole |
| usergroups_teams |
| useridmapper |
| usernotificationevent |
| users_groups |
| users_orgs |
| users_permissions |
| users_roles |
| users_teams |
| users_usergroups |
| usertracker |
| usertrackerpath |
| virtualhost |
| webdavprops |
| website |
| wikinode |
| wikipage |
| wikipageresource |
| workflowdefinitionlink |
| workflowinstancelink |
+---------------------------------------+
183 rows in set (0.32 sec)
you can see here we have 183 tables in Liferay
