You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Next »

The information on this page refers to License Statistics v5.15 or newer, which upgraded MySQL to v5.7. If you are using an earlier version of License Statistics, please refer to the documentation for releases prior to v5.15.

License Statistics can use either an external or embedded MySQL database. The following sections contain information relevant to MySQL database configuration, including:

You can find out more about MySQL at http://www.mysql.com.

Important: Direct SQL queries and manipulation of the database is unsupported. Always make a backup of your database before manipulating it. Manipulating the database can result in database corruption.


The database can be configured in the xflicstat.cfg file. Available settings include the following.

SettingRequiredDefault value set by installerDescription
MYSQL_SERVERYesEMBEDDED64

To use the embedded MySQL server delivered with the application, set this value to EMBEDDED64.

To use an external MySQL server, specify the server name or IP address.

MYSQL_PORTYes3306
MySQL server port.
MYSQL_DATABASEYesxformation_licstat

Name of License Statistics database.

If you use an embedded MySQL server, the database will be created automatically the first time you run License Statistics.

If you use an external MySQL server, the database must be created manually before running License Statistics.

MYSQL_USERNAMEYesrootUsername for the account created in the License Statistics database.
MYSQL_PASSWORDNoemptyPassword for the account created in the License Statistics database.
  • No labels