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