起因是我把访问权限都配置为 :
GRANT ALL PRIVILEGES ON*.* TO 'root' Identified by 'root';
启动hive 发生错误;
步骤一:在hive安装目录下conf(/opt/usr/apps/hive-0.13.1-cdh5.3.6/conf/hive-log4j.properties)文件中查看hive日志文件的位置
步骤二:找到hive的日志文件 ,查看hive的报错信息
得到如下的错误信息(当然 不同的问题所产生的日志是不同的):
Caused by: javax.jdo.JDOFatalDataStoreException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://host1:3306/hive?createDatabaseIfNotExist=true, username = hive. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
java.sql.SQLException: Access denied for user 'hive'@'127.0.0.1' (using password: YES)
发现数据库的权限 HIVE需要的是: root'@'127.0.0.1' 这个IP地址
然后试着在mysql中加上权限:
GRANT ALL PRIVILEGES ON*.* TO 'root'@'%' Identified by 'root';
GRANT ALL PRIVILEGES ON*.* TO 'root'@'localhost' Identified by 'root';
GRANT ALL PRIVILEGES ON*.* TO 'root'@'127.0.0.1' Identified by 'root';
GRANT ALL PRIVILEGES ON*.* TO 'root'@'host1' Identified by 'root';
flush privileges;
再次启动hive成功:[hadoop@host1 conf]$hive
GRANT ALL PRIVILEGES ON*.* TO 'root' Identified by 'root';
本机地址:10.18.252.*** 机器名字:host1
flush privileges;
启动hive 发生错误;
步骤一:在hive安装目录下conf(/opt/usr/apps/hive-0.13.1-cdh5.3.6/conf/hive-log4j.properties)文件中查看hive日志文件的位置
步骤二:找到hive的日志文件 ,查看hive的报错信息
得到如下的错误信息(当然 不同的问题所产生的日志是不同的):
Caused by: javax.jdo.JDOFatalDataStoreException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://host1:3306/hive?createDatabaseIfNotExist=true, username = hive. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
java.sql.SQLException: Access denied for user 'hive'@'127.0.0.1' (using password: YES)
发现数据库的权限 HIVE需要的是: root'@'127.0.0.1' 这个IP地址
然后试着在mysql中加上权限:
GRANT ALL PRIVILEGES ON*.* TO 'root'@'%' Identified by 'root';
GRANT ALL PRIVILEGES ON*.* TO 'root'@'localhost' Identified by 'root';
GRANT ALL PRIVILEGES ON*.* TO 'root'@'127.0.0.1' Identified by 'root';
GRANT ALL PRIVILEGES ON*.* TO 'root'@'host1' Identified by 'root';
flush privileges;
再次启动hive成功:[hadoop@host1 conf]$hive