You can use an external MySQL database with License Statistics if needed. Note that License Statistics supports only MySQL versions 5.5 and newer.
To use an external database with License Statistics:
- Create the database. For example, type the following in the MySQL console:
mysql> CREATE DATABASE database_name; - Edit or replace your existing mysqld configuration file with the MySQL config.ini file included in the License Statistics distribution. These settings are important for performance, because the default mysqld configuration file is not configured for the high volume of data License Statistics pushes through the database.
Note: Each time you restart the MySQL server, make sure it is reading the proper configuration file. - Edit the following settings in the configuration file (xflicstat.cfg):
| Setting | Description |
|---|---|
| MYSQL_SERVER | MySQL server name or IP address. |
| MYSQL_PORT | 3306 (default). |
| MYSQL_USERNAME | Username for the account created in the License Statistics database. |
| MYSQL_PASSWORD | Password for the account created in the License Statistics database. |
| MYSQL_DATABASE | Name of the database created for License Statistics. |