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

[#1]

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,

[#2]

This is a MySQL issue.

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

[#3]

Ye it was running.

[#4]

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.

[#5]

is you jdbc jars are in right place ? 

[#6]

@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.

[#7 · Accepted solution]

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,

[#8]

@Huriye:

What does that mean ?

Please can you explain....