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.

MYSQL Database - HUE connection fails | Unable to connect to database on host machine1

MYSQL Database - HUE connection fails | Unable to connect to database on host machine1

New Contributor

Hello dear ,

I am getting such error while connection Hue with external database (MySql).

 

Setup Database

Configure and test database connections. Create the databases first according to the Installing and Configuring an External Database section of the ...

 

Error:

Hue
 Unable to connect to database on host 'machine1.localdomain.com:3306' from host 'machine1.localdomain.com' using the credential provided.

 

 

Thank you in advanced.

3 REPLIES 3

Re: MYSQL Database - HUE connection fails | Unable to connect to database on host machine1

Expert Contributor

I had this problem and it was that the DataBase port was not entered correctly.   Is :3306 the port #?

 

Could also be the

Database Name:     Username:     Password:   

was not entered correctly.

 

 

Highlighted

Re: MYSQL Database - HUE connection fails | Unable to connect to database on host machine1

New Contributor

Hi dear truonala ,
You can see in the error message that i have properly inserted the  port number as '3306'.

'machine1.localdomain.com:3306

Though its giving an error.

But one thing: 

I am using Centos OS version 7.5 

So do i need to work with MariaDB instead of MySql?

Please reply:

 

 

Re: MYSQL Database - HUE connection fails | Unable to connect to database on host machine1

New Contributor

Hey guys,

 

I've just run into the same issue.

 

Have you managed to get past it?

Don't have an account?
Coming from Hortonworks? Activate your account here