Found it. In Ambari > Hive > Config > Database I had: Database URL: jdbc:mysql://localhost/metastore?createDatabaseIfNotExist=true. You need to change localhost for the host you are trying to connect to, in my case: Database URL: jdbc:mysql://hadoopslave01.*****.*****/metastore?createDatabaseIfNotExist=true. You will probably need to change the bind-adress in your mysql configuration file as well: On ubuntu go to /etc/mysql/mysql.conf.d/mysqld.cnf and change bind-adress: 127.0.0.1 to bind-adress: 0.0.0.0 Then restart mysql (on Ubuntu service mysql restart) and in Ambari > Hive > Config > Database test your connection to the metastore.
... View more
