Databases

SQLite

MySQL

Install MySQL Server

sudo apt update

sudo apt install mysql-server

sudo systemctl start mysql.service

mysql -u root -p

ALTER USER 'root'@'localhost' IDENTIFIED WITH auth_socket;

sudo mysql

mysql -u root -p

CREATE USER 'username'@'host' IDENTIFIED WITH authentication_plugin BY 'password';

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Str0ngPasswd!';

CREATE USER 'gophish'@'localhost' IDENTIFIED BY 'Str0ngPasswd!';

sudo mysql_secure_installation

/etc/mysql/mysql.cnf

[mysqld]
sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

"db_name" : "mysql",
"db_path" : "gophish:@(:3306)/gophish?charset=utf8&parseTime=True&loc=UTC",

CREATE DATABASE gophish CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;