'Using Wrangler with MySQL: A server error occurred when testing the connection. Error: Exception occurred while handling request: string

I am trying to connect a MySQL database via Google Cloud Data Fusion Wrangler. It's a very standard connection and I can connect and do every action with another tool (DBeaver). However, trying to connect with Wrangler, I am getting this message:

A server error occurred when testing the connection. Error: Exception occurred while handling request: string

enter image description here

Any suggestions? Thanks!

google-cloud-data-fusion


Solution 1:[1]

Please follow the instructions on https://cloud.google.com/data-fusion/docs/how-to/using-jdbc-drivers

Once done, you will be able to select the uploaded driver from the dropdown

Solution 2:[2]

For your requirement, you have to use JDBC Driver for connecting to MySQL database.You can use Public IP to setup connection to Wrangler.

Following are the steps to connect to MySQL database using Wrangler

  • Go to Hub in the Cloud Fusion instance and and select the required JDBC Driver.
  • Download the driver and deploy it.
  • Go to Wranglers page and click on Add Connection if you are connecting to MySQL for the first time.
  • Select the MySQL database from the list of databases provided in Wrangler.
  • Add name and JDBC driver along with username, password and other connection arguments.
  • Click on test connection to check the connectivity.

For more details you can check this link.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Sanket9394
Solution 2

Related Questions