Data Connector: MySQL

Modified on Wed, 18 Oct 2023 at 02:34 PM

Introduction

MySQL data can be imported into Gigasheet using the MySQL Data Connector. This includes both MySQL tables and views. Data can be imported on an ad-hoc basis or on a schedule. Once MySQL data added to Gigasheet becomes a standard sheet file, on which all functions can be applied, including the ability to filter, pivot, enrich, and export.




How to get there

Login to Gigasheet > New+ > Data Connectors > search and select MySQL



How to Fill MySQL Connection


Host: This is the URL that will host the connection

Port: The port to connect

Database: The name of the database in MySQL. 

Username/Password: Your username and password to login to MySQL

Tables: Name of the tables you would like to import into Gigasheet. 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article