Connecting to MySQL

The SaveToDB add-in allows connecting to MySQL tables, views, and stored procedures.

The SaveToDB add-in supports the following data providers:

• MySQL ODBC Driver
• MySQL Data Provider for .NET

The add-in ships the .NET data provider. So, you can use it from the box.

You can download and install MySQL ODBC drivers at https://dev.mysql.com/downloads/connector/odbc/.

Microsoft Excel supports MySQL ODBC drivers and does not support .NET data providers.

You can connect to MariaDB databases using MySQL providers and drivers.

Here is a sample of the Database Connection Wizard page where you can select the data provider:

Connecting to MySQL Databases

Use the following server name format for MySQL:

<Server name or IP-address>[;port=<Port>]

Here is a sample of the connection to the s02 database on the localhost:

Below is a sample of the connection to the s02 database on localhost port 3306: