2臺機器:一臺windows+mysql一臺CentOS+hive(CentOS安裝在上面windows下的虛擬機中)虛擬機網絡狀況良好,hive配置基本沒錯,mysql也創建了hive數據庫。但是運行hive命令后,在mysql中生成元數據時出現錯誤:
java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://192.168.99.74:3306/hive, username = frank.
Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------
java.sql.SQLException: null, message from server: "Host '192.168.99.236' is not allowed to connect to this MySQL server"
是虛擬機不被訪問外面的數據庫?還是windows的mysql數據庫不允許被別的機器訪問?還是別的原因?跪求大神解答!
CentOS裝的Hive連接另一臺機器的mysql失敗
慕尼黑8549860
2019-03-01 10:45:34