Creation of a new database

[Deepak Bhatia，修改在14 年前。]

Hi,

As per the Liferay Database Connection Configuration,

For MySql, make sure you create the database first;

create database lportal character set utf8;

Question: Where should I run this command ? Do we have mysql installed with the Liferay 5.2.3 bundle with Tomcat 5.5 ?

Regards

Deepak Bhatia

[Sandeep Nair，修改在14 年前。]

No,

You have to install mysql separately. Liferay bundle comes with default hypersonic db

Regards,
Sandeep

[Deepak Bhatia，修改在14 年前。]

Sandeep Nair:

No,

You have to install mysql separately. Liferay bundle comes with default hypersonic db

Regards,
Sandeep

Hi,

Should I install Mysql from www.apachefriends.com or http://dev.mysql.com/downloads/mysql/ ?

Regards

Deepak Bhatia

[Manish Kumar Gupta，修改在14 年前。]

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

[Deepak Bhatia，修改在13 年前。]

Thanks Manish for the help.

I have installed the (mysql-5.1.46-win32.msi] from the below website. Create the database using mysql.

Put the following in portal-ext.properties

mail.session.mail.smtp.host=10.0.0.6
mail.session.mail.smtp.port=587
mail.session.mail.transport.protocol=smtp
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=*********
schema.run.minimal=true

So I am able to login as [e-mail] without any entries.

It seems I have achieved what I was trying to do.

Thanks

Deepak

Manish Kumar Gupta:

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