✳
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 [email protected] identified by 'mftdb2k';
grant all privileges on MFTDB.* to [email protected] with grant option;
use MFTDB;
source dump.sql;
source schema.sql;
Last modified 4mo ago