Solutions to the failure of sqoop connection to MySQL

stay sqoop When testing, I encountered a problem that I couldn't connect

sqoop The test command

sqoop list-databases --connect jdbc:mysql://172.8.10.0:3306/?autoReconnect=true --username username --password password

If the following error is reported

ERROR manager.CatalogQueryManager: Failed to list databases
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

It's less jar package , hold mysql-connector-java.jar 5 and 8 All versions are put in sqoop Of lib In the document , I don't know which one is missing , Just put it in anyway

https://mvnrepository.com/artifact/mysql/mysql-connector-java/5.1.37

https://mvnrepository.com/artifact/mysql/mysql-connector-java/8.0.15?__cf_chl_f_tk=3siKHYKljMK0Q44MKad784Jfilwk.k2I6ibv4xWiDpY-1642410213-0-gaNycGzNDCU

There are other mistakes , Such as authority issues ,MySQL Can't connect remotely ; There is also a lack of tips jar package , That would be very happy .