...
| 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 uses can use either an external or embedded MySQL database. The following sections contain information relevant to MySQL database configuration, including:
- Database structure
- Backup/restoration and upgrading an embedded database
- Using and upgrading an external MySQL database
| Info |
|---|
You can find out more about MySQL at http://www.mysql.com. |
...
| Info |
|---|
| 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.
| Setting | Required | Default value set by installer | Description |
|---|---|---|---|
| MYSQL_SERVER | Yes | EMBEDDED64 | 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_PORT | Yes | 3306 | MySQL server port. |
| MYSQL_DATABASE | Yes | xformation_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_USERNAME | Yes | root | Username for the account created in the License Statistics database. |
| MYSQL_PASSWORD | No | empty | Password for the account created in the License Statistics database. |