Reply
New Contributor
Posts: 3
Registered: ‎08-17-2018

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

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.

Cloudera Employee
Posts: 111
Registered: ‎04-12-2016

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

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.

 

 

New Contributor
Posts: 3
Registered: ‎08-17-2018

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

[ Edited ]

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:

 

 

Highlighted
New Contributor
Posts: 4
Registered: ‎11-13-2017

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

Hey guys,

 

I've just run into the same issue.

 

Have you managed to get past it?

Announcements