How do I access liferays database

I need to access my local liferays database via sql. How do I open a sql command prompt开发者_StackOverflow中文版 to this database?

Start to use a custom database. Having all in a let's say Mysql database allows you to use all tools available for browsing that database. I think there exists many good tools for Mysql and that way you'll get what you want - easily and without much pain!

I'll describe MySQL database installation.

First of all, you should download that database from official website :

http://dev.mysql.com/downloads/

Than you should create (or change the existing one) file "proper-ext.properties" in your liferay folder. Delete all text in that file and paste this:

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=admin

Also you must create new user (root, admin) and new database and name it "lportal" (create database lportal).

After that, you should open you command line and enter mysqld --console. Then you should open another one command line and enter mysql -u root -p.

Good luck!

Default a HSQL datbase is used (http://hsqldb.org/) (maybe there is aclient to connect to it) Data is store in $LIFERAY_HOME\data\hsql If you want a different db checkout: http://www.liferay.com/community/wiki/-/wiki/Main/Database+Portal+Properties