...
| 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. |
You can use an external MySQL database with License Statistics if needed.
...
- Create the database. For example, type the following in the MySQL console:
mysql>CREATE DATABASE database_name character set latin1 collate latin1_swedish_ci;
where database_name is the name of the database. 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.
Restart the MySQL server.
Info 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.