📙 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_packets=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_PACKETS;

Start MySQL

Start up the MySQL command-line-interface by running the following:

mysql -u root -p

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:
```
CREATE DATABASE threadfix CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
```

2. Create user accounts by using the following commands:

CREATE USER 'threadfix'@'localhost' IDENTIFIED BY 'tfpass';
CREATE USER 'threadfix'@'%' IDENTIFIED BY 'tfpass';
GRANT ALL PRIVILEGES ON threadfix.* TO 'threadfix'@'localhost' IDENTIFIED BY 'tfpass';
GRANT ALL PRIVILEGES ON threadfix.* TO 'threadfix'@'%' IDENTIFIED BY 'tfpass';
FLUSH PRIVILEGES;

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.

Ubuntu MySQL Installation and Configuration