jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.

主要问题是因为mysql的驱动版本太老了。更换驱动即可！

「博客文件分享（勿删）」https://www.aliyundrive.com/s/woQDk8xenER 提取码: a79a

 cp /opt/software/mysql-connector-java-8.0.25.jar /opt/module/hive/lib 

注意事项：先删除原本的mysql驱动 ！！！

vim hive/conf/hive-site.xml 

 注意事项：端口号和数据库密码根据自己情况更改

javax.jdo.option.ConnectionURL
jdbc:mysql://hadoop102:3306/metastore?useSSL=false



javax.jdo.option.ConnectionDriverName
com.mysql.jdbc.Driver



javax.jdo.option.ConnectionUserName
root



javax.jdo.option.ConnectionPassword
000000



hive.metastore.schema.verification
false



hive.metastore.event.db.notification.api.auth
false



hive.metastore.warehouse.dir
/user/hive/warehouse

mysql -uroot -p000000

mysql> create database metastore;

mysql> quit;

[root@hadoop102 software]$ schematool -initSchema -dbType mysql -verbose

完毕！（谢谢浏览 ）（谢谢浏览 ）（谢谢浏览 ）