执行bin/schematool -initSchema -dbType mysql -verbos 初始化hive报错SQL Error code: 1045

浅浅的花香味﹌ 2024-03-02 02:13 53阅读 0赞

### 报错原因 ###

执行命令

bin/schematool -initSchema -dbType mysql -verbos

### 报错信息 ###

`SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/export/server/apache-hive-3.1.3-bin/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/export/server/hadoop-3.3.4/share/hadoop/common/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Metastore connection URL: jdbc:mysql://bigdatanode1:3306/hive?serverTimezone=GMT&createDatabaseIfNotExist=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8 Metastore Connection Driver : com.mysql.jdbc.Driver Metastore connection User: root org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version. Underlying cause: java.sql.SQLException : Access denied for user 'root'@'bigdatanode1' (using password: YES) SQL Error code: 1045 Use --verbose for detailed stacktrace. *** schemaTool failed ***`

### 解决 ###

#### 检查hive-site.xml配置文件是否修改为自己的用户名密码 ####

![在这里插入图片描述][029068b8fd05406d8d75fdd7294ce642.png]

结束！！！  
hy:39

--------------------

误解是人生的常态，理解反而是稀缺的例外。

[029068b8fd05406d8d75fdd7294ce642.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/02/6cfb9efa6dcd49b9b0d8e370ba8d7a1b.png