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

[deepak_ahirwar]

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.

[truonala]

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.

[deepak_ahirwar]

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:

[Koma40k]

Hey guys,

I've just run into the same issue.

Have you managed to get past it?