Was this article helpful?

MySQL

MR900432536.JPG Connecting to a MySQL Database Tutorial Video. This video will walk you through how to connect to a MySQL database as a data source.

 

MySQL_Datasource.png

 

 

Use this datasource to connect to a MySQL Database.

 

For AutoTag and the .NET engine you need the ADO.NET connector which can be found at dev.mysql.com/downloads/connector/net/ - you want the zip file that does not have src in its name. That zip file contains a single file mysql.data.msi which you run to install the connector. Note: Windward only works with MySql 5.0 and later.

For the java engine you need the JDBC connector which can be found at dev.mysql.com/downloads/connector/j/ - either the zip or tar is fine, they both have the same thing.

 

  • Server: Enter the server name here. MySql cannot list servers on the subnet so you always need to type this in.

  • Database: Enter the database name here. This will auto-populate from the server once the server is set. In most cases you will need to set your username & password in order for AutoTag to auto-populate the list. You can type in the name or select from the list.

  • Display Tables: User and User Owned are the same thing for MySQL. User will pull the metadata of just the tables created for a database. System will also pull the system tables MySQL adds to the database used to administer and configure each database.

  • Read in metadata: Check this to read in additional information from the database, primarily the descriptions of tables, views, & columns and the primary key - foreign key relationships. You should always keep this checked.

  • Use Connection String: You can enter the connection string directly instead of entering the Server, Database, & Credentials. When unchecked it will dispkay the connection string AutoTag will generate from your settings.

Demo Server

You can connect to the Windward demo MySQL database as follows. It has the Sakila database.

  • Server: mysql.windward.net

  • Username: demo

  • Password: demo

Important Note on Windward Videos

Can't view the video? See Broken Images and Videos in the Windward wiki and Broken Videos: Vimeo and Firefox for help.

Was this article helpful?
Pages that link here
Page statistics
1540 view(s), 10 edit(s) and 4472 character(s)

Tags

This page has no custom tags set.

Comments

You must to post a comment.

Attach file

Attachments

FileVersionSizeModifiedOptions