liferay 5.2.3 to mysql server

IMG_2933

Create a database and account in MySQL:

create database liferay;
grant all on liferay.* to ‘liferay’@’localhost’ identified by ‘liferay’ with grant option;
grant all on liferay.* to ‘liferay’@’localhost.localdomain’ identified by ‘liferay’ with grant option;

Copy the MySQL JDBC driver mysql.jar to {liferay-home}{tomcat}libext;

In versions 5.2 and after, the configuration of the database is set in a single file, portal-ext.properties, for all application servers. Add the example below to set up MySQL.
{liferay-home}{tomcat}webappsROOTWEB-INFclassesportal-ext.properties

jdbc.default.driverClassName=com.mysql.jdbc.Driver
jdbc.default.url=jdbc:mysql://localhost/liferay?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
jdbc.default.username=liferay
jdbc.default.password=liferay

As of 5.2.2 you can use the connection pools provided by the application server by specifying the JNDI name to be used in portal-ext.properties using the following property:

jdbc.default.jndi.name=jdbc/LiferayPool

This re-establishes the way connections are handled to the behaviour of version 5.1.x
5. Run {liferay-home}{tomcat}binstartup.bat.
6. Open your browser and go to http://localhost:8080 (here we assume that it is a local installation, otherwise use the real host name or IP).
7. Login as an administrator User: test@liferay.com and Password: test.

0 Comments

Leave a reply

Your email address will not be published. Required fields are marked *

*