Hi Suresh, Thanks for advice, why you are so monopoly, You shoul not be. Problem is solution not problem.
Note: I am looking for any user does not matter bcz it is common use Scenario. On Fri, Feb 8, 2013 at 3:31 AM, Suresh Srinivas <sur...@hortonworks.com>wrote: > Please only use CDH mailing list and do not copy this to hdfs-user. > > > On Thu, Feb 7, 2013 at 7:20 AM, samir das mohapatra < > samir.help...@gmail.com> wrote: > >> Any Suggestion................... >> >> >> On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra < >> samir.help...@gmail.com> wrote: >> >>> Hi All, >>> I could not see the hive meta store DB under Mysql database Under >>> mysql user hadoop. >>> >>> Example: >>> >>> $> mysql –u root -p >>> $> Add hadoop user (CREATE USER ‘hadoop'@'localhost' IDENTIFIED BY ‘ >>> hadoop';) >>> $>GRANT ALL ON *.* TO ‘hadoop'@‘% IDENTIFIED BY ‘hadoop’ >>> $> Example (GRANT ALL PRIVILEGES ON *.* TO 'hadoop'@'localhost' >>> IDENTIFIED BY 'hadoop' WITH GRANT OPTION;) >>> >>> Bellow configuration i am follwing >>> ------------------------------------------------ >>> >>> <property> >>> <name>javax.jdo.option.ConnectionURL</name> >>> >>> <value>jdbc:mysql://localhost:3306/hadoop?createDatabaseIfNotExist=true</value> >>> </property> >>> <property> >>> <name>javax.jdo.option.ConnectionDriverName</name> >>> <value>com.mysql.jdbc.Driver</value> >>> </property> >>> <property> >>> <name>javax.jdo.option.ConnectionUserName</name> >>> <value>hadoop</value> >>> </property> >>> <property> >>> <name>javax.jdo.option.ConnectionPassword</name> >>> <value>hadoop</value> >>> >>> </property> >>> >>> >>> Note: Previously i was using cdh3 it was perfectly creating under mysql >>> metastore DB but when i changed cdh3 to cdh4.1.2 with hive as above subject >>> line , It is not creating. >>> >>> >>> Any suggestiong.......................... >>> >>> Regrads, >>> samir. >>> >> >> > > > -- > http://hortonworks.com/download/ >