Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Nikhil Sood
Liferay 6.1 - MySQL - Database connection could not be established.
September 19, 2012 12:58 AM
Answer

Nikhil Sood

Rank: Junior Member

Posts: 34

Join Date: August 12, 2009

Recent Posts

Hello,

I am trying to install Liferay 6.1 with MySQL 5.5.
1. I installed MySQL and set the root user with a valid password.
2. I checked my connection using the same password in the MySQL Workbench, and it is successful.
3. I successfully installed liferay 6.1.
4. In the basic configuration wizard, I selected MySQL and it defaulted the JDBC URL and JDBC Driver Class Name.
5. I entered the UserName and Password for MySQL.

No when I clicked on Finish Configuration button, I get the following error:

Database connection could not be established. Please check your connection settings.

Sceenshot is attached for reference. Appreciate any responses.

Thanks,
Nikhil
Attachment

Attachments: Database connection Error.jpg (167.7k)
Oliver Bayer
RE: Liferay 6.1 - MySQL - Database connection could not be established.
September 19, 2012 1:14 AM
Answer

Oliver Bayer

Rank: Liferay Master

Posts: 875

Join Date: February 18, 2009

Recent Posts

Hi Nikhil,

I'm not sure but shouldn't the jdbc url contains the port of your mysql instance? Otherwise check the tomcat console logs for a jdbc exception.

Greets Oli
Nikhil Sood
RE: Liferay 6.1 - MySQL - Database connection could not be established.
September 19, 2012 1:34 AM
Answer

Nikhil Sood

Rank: Junior Member

Posts: 34

Join Date: August 12, 2009

Recent Posts

Hi Oli,

Thanks for your response. I found my mistake. Basically you need to create a database schema in MySQL and then replace it with IPortal in the JDBC URL.

Cheers,
Nikhil
serafino sorleti
RE: Liferay 6.1 - MySQL - Database connection could not be established.
September 25, 2012 5:20 AM
Answer

serafino sorleti

Rank: New Member

Posts: 1

Join Date: September 25, 2012

Recent Posts

Nikhil Sood:
Hi Oli,

Thanks for your response. I found my mistake. Basically you need to create a database schema in MySQL and then replace it with IPortal in the JDBC URL.

Cheers,
Nikhil


Thanks a lot!!!
Jiechao Wu
RE: Liferay 6.1 - MySQL - Database connection could not be established.
September 12, 2013 1:47 AM
Answer

Jiechao Wu

Rank: New Member

Posts: 1

Join Date: September 12, 2013

Recent Posts

Hello,
I want to ask a question: after creating a database schema in MySQL, how to replace it with IPortal in the JDBC URL?
Thanks!

Cheers,
xiaodanding
Priyanka M
RE: Liferay 6.1 - MySQL - Database connection could not be established.
January 6, 2014 11:46 PM
Answer

Priyanka M

Rank: New Member

Posts: 7

Join Date: September 26, 2011

Recent Posts

Hello Jiechu,

Am sure you already have an answer by now - but for the sake of others who might stumble on this post.
You need to replace the "lportal" in JDBC URL that appears in the box by default with the Schema name you just created.

Other option for ease is you could use the name lportal for the schema you create and then you dont need to make any changes. (Not a good thing though for production instances using default values)

Cheers,
Priyanka.