Created 10-21-2016 10:49 AM
Hello Team,
I need to know the configuration properties to set in blueprint for MYSQL. I need to set the root password while enabling the mysql component via blueprint.
Thanks
Created 10-24-2016 09:10 AM
AFAIK, We cannot set root password for mysql using Ambari blueprints. Setting root password requires mysqladmin etc. mysql commands and with Ambari blueprints, we can only set mysql password for daemon users for metastore databases like Oozie/Hive etc.
Created 10-24-2016 04:41 AM
++ @Kuldeep Kulkarni Can you help...
Created 10-24-2016 09:10 AM
AFAIK, We cannot set root password for mysql using Ambari blueprints. Setting root password requires mysqladmin etc. mysql commands and with Ambari blueprints, we can only set mysql password for daemon users for metastore databases like Oozie/Hive etc.
Created 10-25-2016 06:23 AM
@Kuldeep Kulkarni , thanks , can we create new user/DB with admin privilege in mysql ? like we set in hive connection properties ? incase Ranger required to create a DB (rangerdb) and user, if db not exist hive can create a DB and connection user, like wise Ranger dont have the properties ? If i automate HIVE and RANGER for new cluster deployment, how i can use HIVE mysql DB for Ranger, without mysqladmin commands , all i have to do in blueprint only.