hive初始化SQL Error code：1045错误解决方法

1、问题：

[hadoop@node1 hive]$ bin/schematool -initSchema -dbType mysql -verbos
Metastore connection URL:        jdbc:mysql://node1:3306/hive?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'@'node1' (using password: YES)
SQL Error code: 1045
Use --verbose for detailed stacktrace.
*** schemaTool failed ***

        表示MySQL root用户与密码不匹配，需要进行密码或用户进行修改，这里修改密码为root用户密码

2、解决办法：

如下图所示，需要将password替换为root密码，在进行初始化

  <property>
    <name>javax.jdo.option.ConnectionPassword</name>
    <value>password</value>
  </property>