@Prabhat Ratnala This should answer your question Hope that helps ... View more

@Ameya Sakhalkar Don't worry you can create a new Ranger database as follow change username and password to suit your environment. mysql -u root -p{rootpassword} CREATE USER 'ranger'@'localhost' IDENTIFIED BY 'ranger_password'; GRANT ALL PRIVILEGES ON *.* TO 'ranger'@'localhost'; GRANT ALL PRIVILEGES ON *.* TO 'ranger'@'rangerDBhost'; GRANT ALL PRIVILEGES ON *.* TO 'ranger'@'%'; GRANT ALL PRIVILEGES ON *.* TO 'ranger'@'localhost' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'ranger'@'rangerDBhost' IDENTIFIED BY 'ranger' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'ranger'@'localhost' IDENTIFIED BY 'ranger_password' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'ranger'@'%' WITH GRANT OPTION; FLUSH PRIVILEGES; # mysql -u ranger -pranger CREATE DATABASE ranger; ################ simpler version ################### create database ranger; create user ranger identified by 'ranger'; grant all on ranger.* to ranger; Flush privileges; Let me know if that helps ... View more