question Unable to connect to database on host 'clouderam' from host 'clouderam' using the credential provid in Support Questions

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

Huriye — Thu, 15 Mar 2018 05:39:37 GMT

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,

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

GeKas — Thu, 15 Mar 2018 08:01:05 GMT

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

Huriye — Thu, 15 Mar 2018 09:26:16 GMT

Ye it was running.

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

GeKas — Thu, 15 Mar 2018 10:27:15 GMT

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

csguna — Sat, 17 Mar 2018 01:45:05 GMT

is you jdbc jars are in right place ?

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

bgooley — Sat, 17 Mar 2018 03:51:22 GMT

@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

Huriye — Wed, 21 Mar 2018 15:27:50 GMT

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,

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

deepak_ahirwar — Thu, 25 Oct 2018 05:17:07 GMT

@Huriye:

What does that mean ?

Please can you explain....