我的mysql是裝在本地機(jī)器win7操作系統(tǒng)下的，服務(wù)正常，本地登錄正常。hive裝在linux虛擬機(jī)上，虛擬機(jī)與本機(jī)網(wǎng)絡(luò)沒有問題，防火墻已關(guān)，hadoop安裝也沒有問題。 我在liunx虛擬機(jī)上安裝了mysql的客戶端，通過命令mysql -uhive -paxx1314 -h192.168.120.1 正常登錄，信息如下[root@zchlinux conf]# mysql -uhive -paxx1314 -h192.168.120.1 Welcome to the MySQL monitor. ?Commands end with ; or \g. Your MySQL connection id is 9 to server version: 5.0.18-ntType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> show databases; +--------------------+ | Database ? ? ? ? ? | +--------------------+ | information_schema | | hivedb ? ? ? ? ? ? | | test ? ? ? ? ? ? ? | +--------------------+ 3 rows in set (0.03 sec)mysql>但當(dāng)我啟動hive時報錯，報錯信息如下：[root@zchlinux conf]# hiveLogging initialized using configuration in jar:file:/opt/apache-hive-0.13.0-bin/lib/hive-common-0.13.0.jar!/hive-log4j.properties Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiateorg.apache.hadoop.hive.metastore.HiveMetaStoreClient ? ?at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:344) ? ?at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:681) ? ?at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:625) ? ?at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ? ?at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ? ?at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ? ?at java.lang.reflect.Method.invoke(Method.java:601) ? ?at org.apache.hadoop.util.RunJar.main(RunJar.java:160) Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient ? ?at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1412) ? ?at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.(RetryingMetaStoreClient.java:62) ? ?at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:72) ? ?at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2444) ? ?at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2456) ? ?at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:338) ? ?... 7 more Caused by: java.lang.reflect.InvocationTargetException ? ?at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ? ?at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ? ?at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ? ?at java.lang.reflect.Constructor.newInstance(Constructor.java:525) ? ?at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1410) ? ?... 12 more Caused by: javax.jdo.JDOFatalDataStoreException: Unable to open a test connection to the given database. JDBC url =jdbc:mysql://192.168.120.1:3306/hivedb?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=UTF-8, username =hive. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). OriginalException: ------ java.sql.SQLException: Access denied for user 'hive'@'192.168.120.128' (using password: YES) ? ?at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) ? ?at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) ? ?at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) ? ?......... ? ?..... ? ?..hive的配置文件hivehive-site.xml內(nèi)容如下：<?xml version="1.0"?>< ?xml-stylesheet type="text/xsl" href="configuration.xsl"?>javax.jdo.option.ConnectionURLjdbc:mysql://192.168.120.1:3306/hivedb?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=UTF-8javax.jdo.option.ConnectionDriverNamecom.mysql.jdbc.Driverjavax.jdo.option.ConnectionUserNamehivejavax.jdo.option.ConnectionPassWordaxx1314