While deploying mysql via a Blueprint , can i set root password mysql ? So properties for mysql is available ?

[#1]

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

[#2]

++ @Kuldeep Kulkarni Can you help...

[#3 · Accepted solution]

@ranjith

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.

[#4]

@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.