Page Comparison

Setup MySQL Application Integration on Zilla

1. Visit the Zilla application and login using your admin credentials and then click Add Applicationin the top right.

   Image Modified

    

2. A window with a search bar appears, type in MySQL in the search bar and hit enter. MySQL app entry will appear at the top of the list, click Add to Applications button to the right.

   Image Modified

3. Fill in the form with appropriate details and then click Add to Applications.

   Image Modified

4. You will have the MySQL app added into applications tab and a detailed view of MySQL application appears. Click gear icon in top right corner. Integration configuration pop up will appear.

   Image Modified

5. Enable the Zilla Universal Sync (ZUS) and fill in the config details.
   All or any of the configurations can be kept blank here and can be provided in the ZINC local configurations. The configurations are

   1. Database Server Host:

...

1. 1. The host in the database connection string specifies the hostname or IP address of the database server.

   2. Database Server Port:

...

1. 1. The port in the database connection string specifies the port number on which the database server is listening. The default value is 3306.

   2. Database Name

...

1. 1. : The database name in the database connection string specifies the name of the database to connect to.

   2. Database Connection Parameters: It the parameters string from the database connection string. e.g. retry=true&service_name=Zilla

   3. Database Query: It is the query to retrieve the data from the database. This should be readonly query.

   4. Database Dialect: The dialect in the database connection string specifies the type of database you are connecting to. The dialect value should be mysql .

   5. Database Driver: The driver in the database connection string specifies the database driver to be used for the connection. The driver value should be mysqlconnector .

   6. Database Connection String: The database connection string is an alternative method to configure the database connection. Instead of specifying individual values like host, port, database, username, password, dialect, and driver, you can provide a single connection string. The format should be: 'dialect+driver://username:password@host:port/database?parameters'. If this value is provided, it will be masked after saving because it contains username and password.

   7. Database User: The username in the database connection string specifies the user account to connect to the database.

   8. Database Password: The password in the database connection string specifies the password for the user account to connect to the database.
      

      Image Added

2. Click Next and the sync will begin.

...