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.

Connecting to hive mysql using mysql-conncetor/j

Highlighted

Connecting to hive mysql using mysql-conncetor/j

New Contributor

Hi,

I am setting up a brand new installation of Ambari on a CentOS7. I ran through the documentation and stuck at step 7 where I have to connect othe Databases.

I have a running mysql 8 on another cluster which I called node 1 and the ambari server is running on a cluster which is called host.

I followed the instruction given on

https://docs.hortonworks.com/HDPDocuments/Ambari-2.7.3.0/administering-ambari/content/amb_using_hive...


and there I have my first question:


Step1:

  1. Runambari-server setup --jdbc-db=mysql --jdbc-driver=/path/to/mysql/mysql-connector-java.jar

I used /usr/share/java/mysql-connector-java.jar as /path/to/mysql/

the rights on this file are set to 644

and then I have to run the same command again?


next I logged into mysql on node1 directly and created th users with the privileges as given in the documentation.


When I now try to test the connection I am getting the error


Unable to connect to the DB. Please check DB Connection properties.


this is my databse URL

/usr/share/java/mysql-connector-java.jar


So it looks like I am not able to connect to the DB but I don´t know where the issue is.


_Any help is more than welcome