hive启动报错Caused by: java.sql.SQLException: Access denied for user ‘root‘@‘master‘ (using password: YE

最新推荐文章于 2023-04-28 09:09:24 发布

原创最新推荐文章于 2023-04-28 09:09:24 发布 · 470 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #开发语言 #hive #hadoop

hadoop+hive 专栏收录该内容

2 篇文章

订阅专栏

博客涉及Java开发语言，以及Hadoop和Hive相关内容。Java是常用开发语言，Hadoop是大数据处理框架，Hive是基于Hadoop的数据仓库工具，它们在信息技术领域有重要应用。

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

熏陶

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

kubernetes中 mysql集群出现Access denied for user ‘root‘@‘localhost‘ (using password: NO)

jstang的博客

10-23

7822

最近有网友私信，在k8s部署的mysql集群设置了root密码后，所有节点的日志都报错 Access denied for user ‘root’@‘localhost’ (using password: NO)，于是我就模拟了一下，是这么个情况：其实排查思路很清晰，Web UI 显示Readliness组件报错，日志也报错，日志报错是由于livenessProbe这个组件。就是这两货进不...

HIve初始化报错SQL Error code: 1045

goTsHgo的博客

11-15

3797

问题描述：执行命令 [localhost@hadoop102 hive]$ /opt/module/hive/bin/schematool -initSchema -dbType mysql -verbose 进行初始化hive，详细报错如下： [localhost@hadoop102 hive]$ /opt/module/hive/bin/schematool -initSchema -dbType mysql -verbose Metastore connection URL...

参与评论您还未登录，请先登录后发表或查看评论

配置hive遇到java.sql.SQLException:Access denied for user root master(using password YES)解决方法

ITpyi的博客

05-31

5001

对于配置hive时所遇到的问题之一，都很头疼，在此总结一下遇到此问题的解决方法； 1、用户’root’@‘localhost’（使用密码：YES）拒绝访问出现这种原因有以下原因及解决方法： 1、密码错误用这个账号和密码登录mysql能够登录，但是当用schematool对mysql进行初始化的时候却出错。原因就在于mysql的安装。。。。利用hive初始化数据库的时候是随机找的，可能找到的是没有密码，和hive-site.xml文件中的配置不匹配，导致出错。这个mysql是用来装元数据的。解决方法

hive启动报错Caused by: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.hdfs.server.namenode.Safe

weixin_42599429的博客

08-06

1250

原因是没有关闭安全模式解决hdfs dfsadmin -safemode leave

hive启动报错Caused by: java.net.UnknownHostException: cluster ... 21 more

Tate的博客

12-30

4367

hive启动报错Caused by: java.net.UnknownHostException: cluster … 21 more hadoop配置HA后启动hive报错 [root@master hadoop]# hive Logging initialized using configuration in jar:file:/usr/local/soft/hive-1.2.1/lib/...

hive启动失败显示：Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time

m0_54861980的博客

10-03

973

【hive启动报错】Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value ‘EDT’ is unrecognized or represents more than one time zone.

Caused by: java.sql.SQLException: Access denied for user 'hive ' @'localhost'(using password: YES)

09-28

Caused by: java.sql.SQLException: Access denied for user 'hive'@'localhost'(using password: YES) 错误是由于用户'hive'在本地主机上没有足够的权限导致的。解决方法如下： 1. 首先，确保您输入的用户名和密码...

Caused by: java.sql.SQLException: Access denied for user 'hive'@'Liliang-01' (using password: YES)

06-11

Hive Metastore 连接 MySQL 时出现 `Access denied for user 'hive'@'Liliang-01' (using password: YES)` 的错误，通常是由以下原因引起的：MySQL 用户权限配置不当、连接参数设置错误或主机名解析问题。...

[root@localhost lib]# schematool -dbType mysql -initSchema -verbose Metastore connection URL: jdbc:mysql://localhost/hive_metastore?useSSL=false&serverTimezone=UTC Metastore Connection Driver : com.mysql.cj.jdbc.Driver Metastore connection User: hive org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version. Underlying cause: java.sql.SQLException : Access denied for user 'hive'@'localhost' (using password: YES) SQL Error code: 1045 org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version. at org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getConnectionToMetastore(HiveSchemaHelper.java:94) at org.apache.hive.beeline.HiveSchemaTool.getConnectionToMetastore(HiveSchemaTool.java:169) at org.apache.hive.beeline.HiveSchemaTool.testConnectionToMetastore(HiveSchemaTool.java:475) at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:581) at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:567) at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1517) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:323) at org.apache.hadoop.util.RunJar.main(RunJar.java:236) Caused by: java.sql.SQLException: Access denied for user 'hive'@'localhost' (using password: YES) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:829) at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:449) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:242) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.hadoop.hive.metastore.tools.HiveSchemaHelper.getConnectionToMetastore(HiveSchemaHelper.java:88) ... 11 more *** schemaTool failed ***

最新发布

06-17

当遇到 `Access denied for user 'hive'@'localhost' (using password: YES)` 错误时，通常与用户权限、密码配置或连接方式有关。以下是详细的解决方案： #### 1. 确认 MySQL 用户权限确保 MySQL 中已正确创建 `...

2023-05-14 06:47:47,352 INFO mapreduce.Job: Task Id : attempt_1684070500215_0004_m_000003_1, Status : FAILED Error: java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: Access denied for user 'hive'@'localhost' (using password: YES) at org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:77) at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:137) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:763) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:347) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:174) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1729) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:168) Caused by: java.lang.RuntimeException: java.sql.SQLException: Access denied for user 'hive'@'localhost' (using password: YES)

05-15

这个错误提示显示任务失败了，因为执行 Sqoop 的时候连接 Hive 数据库时，填写的用户名和密码不正确。具体来说，用户名为 'hive' 的用户在本地（localhost）使用给定的密码认证... ...可能需要联系管理员来解决这个问题。

搭建Hive远程模式初始化的时候报错Access denied for user ‘root‘@‘node1‘(using password:YES)

weixin_43717875的博客

02-13

2092

在学习Hive远程模式的时候报错 Underlying cause: java.sql.SQLException : Access denied for user 'root'@'node1' (using password: YES) 可以看出是权限的错误在在优快云查询之后发现可能是root只有本地的权限所以无法访问别的机子用select user,host from user;可以查看用户名和权限现在是root只有本地权限没有所有权限的样子这是只在进入mysql之后直.

HIVE-ERROR 1045 (28000): Access denied for user ‘root‘@‘%‘ (using password: YES)

weixin_55008454的博客

04-28

287

'root'是密码。mysql远程连接密码不对。

hive启动失败报异常

baidu_35310727的博客

03-18

6984

hive突然就不能启动了,之前明明是好的,莫名其妙的报如下错误:解决方法: 杀掉一个run jar 进程,莫名其妙的就好.后来了解到可能是因为hive的元数据库是Derby,不支持同时多用户操作(如果理解的不对烦请)指正.Logging initialized using configuration in jar:file:/home/soft/apache-hive-1.2.0-bin/l...

hive创建库Underlying cause: java.sql.SQLException : Access denied for user

lucky的专栏

01-17

4143

grant all privileges on *.* to root@'%' identified by 'passwd'; 将数据库赋予权限

weixin_45427757的博客

10-11

1237

Caused by: javax.jdo.JDOFatalDataStoreException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://Itstudy:3306/onhive, username = root. Terminating connection pool (set ...

配置hive元数据到mysql后启动不了 java.sql.SQLException: Access denied for user ‘root‘@‘hd101‘ (using password:

JavaBigData的博客

05-23

1576

只能保留 host=%的，其他都需要删掉 Caused by: java.sql.SQLException: Access denied for user 'root'@'hd101' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at co

Caused by: java.sql.SQLException: Access denied for user ‘root ‘@‘localhost‘ (using password: YES)

ly1316221439的博客

02-08

2419

数据库连接错误

Exception in thread “main“ java.sql.SQLException: org.apache.hive.service.cli.HiveSQLException: Erro

weixin_45955039的博客

07-09

2265

Exception in thread “main” java.sql.SQLException: org.apache.hive.service.cli.HiveSQLException: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask at org.apache.hive.service.cli.operat

Exception in thread "main" org.apache.hive.service.cli.HiveSQLException: java.io.IOException: org.

qq_34896163的博客

12-11

5446

在hive命令行中执行 hive和hbase整合的表 hhh_tj_atmosphere_history 可以正常执行，但是通过java jdbc hiveserver2 就不可以（通过hiveserver2访问hive自建表就可以，就是不能访问整合后的表）。 Running:select * from hhh_tj_atmosphere_history 执行“select * query...