Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Unable to connect to database on host 'clouderam' from host 'clouderam' using the credential provid

SOLVED Go to solution

Unable to connect to database on host 'clouderam' from host 'clouderam' using the credential provid

Explorer

Hello,

 

I have configured external database as mysql but I get an error while I try to test the connection which error message as in below;

 

Unable to connect to database on host 'clouderam' from host 'clouderam' using the credential provid

 

Can anyone help me on this?

 

Thank,

 

Regards,

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Unable to connect to database on host 'clouderam' from host 'clouderam' using the credential pro

Explorer

Hi, 

 

I have found the solution. I have used original mysql database for cloudera that is why I had errors. I created anoher database on mysql the I have define the database on db.properties file.

 

Thank you for your helps.

 

Regards,

7 REPLIES 7

Re: Unable to connect to database on host 'clouderam' from host 'clouderam' using the credential pro

Expert Contributor

This is a MySQL issue.

 

Have you checked that mysql is running and you are able to connect?

Re: Unable to connect to database on host 'clouderam' from host 'clouderam' using the credential pro

Explorer

Ye it was running.

Re: Unable to connect to database on host 'clouderam' from host 'clouderam' using the credential pro

Expert Contributor

Have you tried using "-h clouderam" in your command?

Permissions (in MySQL) differ whether you are connected as 'user'@'localhost' or 'user'@'clouderam'

By using "-h clouderam" you are connected as 'user'@'clouderam' and you should grant permissions to this user.

Re: Unable to connect to database on host 'clouderam' from host 'clouderam' using the credential pro

Champion

is you jdbc jars are in right place ? 

Re: Unable to connect to database on host 'clouderam' from host 'clouderam' using the credential pro

Super Guru

@Huriye,

 

The error message is more of a generic error that is returned if something about the connection to the database fails.  You might try checking the Cloudera Manager log for more information and hopefully a stack trace or SQL error.

Re: Unable to connect to database on host 'clouderam' from host 'clouderam' using the credential pro

Explorer

Hi, 

 

I have found the solution. I have used original mysql database for cloudera that is why I had errors. I created anoher database on mysql the I have define the database on db.properties file.

 

Thank you for your helps.

 

Regards,

Highlighted

Re: Unable to connect to database on host 'clouderam' from host 'clouderam' using the credential pro

New Contributor
@Huriye:

What does that mean ?

Please can you explain....