As of December 31st, 2023 ThreadFix 2.X has reached End of Life and is no longer supported. For any further information please contact the Success and Implementation team.
Ubuntu MySQL Installation and Configuration
You will learn
How to install and configure MySQL versions 5.6 and 5.7 on MacOS. These instructions were developed and tested against Ubuntu 16.04.
Prerequisites
Audience: IT Professional and/or End User
Difficulty: Intermediate
Time needed: Approximately 30 minutes
Tools required: MySQL versions 5.6 or 5.7
Installing MySQL (Highly Recommended)
ThreadFix currently supports MySQL versions 5.6 and 5.7. It is not yet compatible with version 8.
Run the following command:Â
sudo apt-get install mysql-server-5.7
You will be prompted during installation to create a password for the 'root' user. Keep this password in a secure location.
Options for Large Data Sets
To help the MySQL server to work with large data sets, we recommend allocating more than the 8GB of memory stated in our hardware requirements for the DB server.
Additionally, edit the MySQL config file (e.g., /etc/mysql/mysql.conf.d/mysqld.cnf), adding the following lines under the "[mysqld]' header (or editing the existing values, if already present):
innodb_buffer_pool_size=12G
tmp_table_size=6G
max_heap_table_size=6G
max_allowed_packet=1G
Restart the server for the changes to take effect.
You can confirm the changes afterward with the following query (unit=GB):
select CONCAT(@@innodb_buffer_pool_size/POWER(1024,3),'G') AS INNODB_BUFFER_POOL_SIZE,CONCAT(@@tmp_table_size/POWER(1024,3),'G') AS TMP_TABLE_SIZE,CONCAT(@@max_heap_table_size/POWER(1024,3),'G') AS MAX_HEAP_TABLE_SIZE,CONCAT(@@max_allowed_packet/POWER(1024,3),'G') AS MAX_ALLOWED_PACKET;
Start MySQL
Start up the MySQL command-line-interface by running the following:
Create ThreadFix Database and Accounts
1. Update MySQL Character Set and Create the threadfix database:
MySQL does not, by default, support the full Unicode character set. ThreadFix requires the MySQL character set to be updated to utf8mb4. Running the following command will create the threadfix database and set the correct encoding:
2. Create user accounts by using the following commands:
Change 'threadfix' and 'tfpass' to a more secure username and password
More information on creating users and their permissions in MySQL can be found here.
After you have finished creating a new user, or at any time, use the EXIT
 command to exit the MySQL command-line-interface.
ThreadFix Installation
Now that you've completed the Ubuntu Enterprise Setup and MySQL Installation and Configuration, proceed to the ThreadFix Installation page.
Â
www.threadfix.it | www.coalfire.com
Copyright © 2024 Coalfire. All rights reserved.
This Information Security Policy is CoalFire - Public: Distribution of this material is not limited.