✳️Setup the Database

$ vi /etc/my.cnf

Replace the entire contents of the file with the following lines:

[mysqld]
# General settings
default-authentication-plugin=mysql_native_password
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
max_connections = 1200
default-time-zone='+00:00'
wait_timeout=31536000
secure-file-priv = ""
skip-log-bin
# Password settings
validate_password.check_user_name =  ON
validate_password.length = 6
validate_password.mixed_case_count = 0
validate_password.number_count = 0
validate_password.policy = LOW
validate_password.special_char_count = 0
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

Save and exit with :x

Restart the MySQL server:

$ systemctl restart mysqld

Download the database setup scripts from one of the MFT bootstrap nodes:

$ wget http://bnd001.miftycoin.com/api/dump?clearexcludes=true -O dump.sql
$ wget http://bnd001.miftycoin.com/api/schema -O schema.sql

Run the MySQL client as "root":

$ mysql -u root -p

Enter the following commands:

create database MFTDB;
create user mftserv@localhost identified by 'mftdb2k';
grant all privileges on MFTDB.* to mftserv@localhost with grant option;
use MFTDB;
source dump.sql;
source schema.sql;

Last updated