Connect to MySQL

Click New on the Connection menu.

Select MySQL.

Connection name: assign a name.

Server name: assign IP address or Server name.

User: enter the user id.

Password: enter the database password.

Port: Assign a port number - default port for MySQL database Server is "3306".

Database: enter the database name you want to connect to.

Connection timeout: define the time out setting in seconds.

SQL dialect: define which MySQL Server SQL dialect to use. That should be consistent with the MySQL Server version of your database.

Enable Offline mode: Learn more here

Select User Groups who can view the Connection: Assign user groups with privileges to open objects from this connection.

Click Ok to establish the connection.

Important!

In order to fully exploit all MS Excel© export functionality it is recommended that you install the MySQL Connector-ODBC 3.51 driver.

Please download and install form here:

Related

Connect to DB2