This page details how to configure a connection to a MySQL database. Note that in some cases you may need to update your JDBC driver, so it is a good idea to consult the table of supported databases.
To connect Ignition to MySQL database
- From the Gateway, go to the Configure section.
- From the menu on the left, select Databases > Connections.
The Database Connections page is displayed.
- Look for the blue arrow, click on Create new Database Connection....
- Select the MySQL ConnectorJ driver and click Next.
Database connections in Ignition are powered by JDBC drivers. Ignition ships with drivers for Microsoft SQL Server, MySQL, Oracle, and a few others.
- On the New Database Connection page, enter the following information:
Name: MySQL (use a meaningful name such as MySQL)
Connect URL: jdbc:mysql://localhost:3306/test (By default MySQL creates an empty database called test)
As you see in the example above, MySQL uses the following Connect URL format:
Where hostaddress is the address of the machine with MySQL installed, for example: localhost, 192.168.1.1, db-server, etc.
and database specifies the database schema the connection will target. It's important to understand that a MySQL server can host many database files. The connection will target one database.
- To configure the connection, enter the following information:
Password: mysql (password is what you entered during MySQL server installation, mysql is the password for this example)
Extra Connection Properties: Leave at the default value. By default, the zeroDateTimeBehavior parameter is defined and it is usually not necessary to add more parameters unless you are planning to store text outside of the range of 7-bit ASCII (a-z). If you are, add useUnicode=yes;characterEncoding=utf8; to the end of the extra connection properties, including the semi-colons.
- Click on Create New Database Connection at the bottom of the form. Your connection is now created and the Database Connections page is displayed showing the Status of your connection as Valid.
- To display the details about the status of your database connection, see the Note on the above window and click on the Database Connection Status link. This will display any errors if your status is Faulted, in this example it shows the status as being Valid.
- No labels