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 <[email protected] > wrote: > Any Suggestion................... > > > On Thu, Feb 7, 2013 at 4:17 PM, samir das mohapatra < > [email protected]> 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/
