@Anup Shirolkar Please try using "%" wildcard for the granting. Example: grant all on *.* to 'anup'@'%.cloudapp.net'; OR grant all on *.* to 'anup'@'%'; . Please see the doc for more details: https://dev.mysql.com/doc/refman/5.7/en/grant.html The _ and % wildcards are permitted when specifying database names in GRANT statements that grant privileges at the database level. ... View more

@uri ben-ari The error indicates that you are not passing the correct "zookeeper.connect" property value to the flag "--zookeeper" in the command line. You can get the "zookeeper.connect" value from Ambari UI --> Kafka --> Configs --> Kafka Broker --> "zookeeper.connect" In my case the value was : "amb25103.example.com:2181,amb25102.example.com:2181,amb25101.example.com:2181" So i had to use the following command: Example: # /usr/hdp/2.6.0.3-8/kafka/bin/kafka-preferred-replica-election.sh --zookeeper amb25103.example.com:2181,amb25102.example.com:2181,amb25101.example.com:2181 . ... View more

@Pathan Shehbaz While upgrading from HDP 2.5 to HDP 2.6 you do not need to much concern about the kerberos, it will be taken care by ambari. However you can take a look at the following doc for prerequisite of the upgrade: https://docs.hortonworks.com/HDPDocuments/Ambari-2.5.1.0/bk_ambari-upgrade/content/upgrading_hdp_stack.html . >>> Regarding your query on "downgrade ambari...2.5 to 2.3 on VMs" - That is not possible and not recommended either. Because once the ambari DB schema is upgraded to the higher version then there is no rollback command. So you can only move ahead to the later version. # ambari-server upgrade . (NOT RECOMMENDED) But if you really wan to downgrade ambari then you will have to then you will need to have the previous version of ambari DB dump along with the "/etc/ambari-server/conf" directory backup (specially the ambari.properties) and then you will have to remove the higher version of ambari (using yum remove ambari-server & ambari-agent) and then you will have to do the same on all hosts to downgrade the ambari agent by uninstalling the higher version of agent and installing the lower version of agent there (but make sure to take a backup of "/etc/ambari-agent/conf". Then you can restore the Previous version of ambari's DB dump to get the older version of ambari installed. . ... View more