Hello guys, I am facing the same issue. and also following the necessary steps that you people taken to resolve issue. but still i am facing same issue.I have root password of my sql but for drpping hive data base when i fire command show databases; It give me the ERROR msg. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. Please tell me the solution to fix it asap. Thanks in advance. ... View more