MiftyCoin Broker Node Configuration
  • 👋Welcome!
  • Pre-Setup
    • 🧭Prerequisites
    • 🎛️Setup your DNS
    • 🖥️Access your Server
  • 💽Install the Prerequisites
  • SETUP
    • 🔥Setup the Firewall
    • 🐈Update the Tomcat Configuration
    • 🐬Start and Reload Tomcat and MySQL
    • 🌐Webmin Configuration
    • ✳️Setup the Database
    • 👩‍💻Install the Code
    • ⚒️Test your Installation
  • Configuration
    • 🔐Generate an Application Key
    • 💻Get your Laptop/Desktop IPv4 Address
    • ⚙️Configure your Node
    • 👨‍💻Update the Data in your Node
    • 💾Upgrade your Node to the Latest Version
    • ⚒️Test your Configuration
Powered by GitBook
On this page
  1. SETUP

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;
PreviousWebmin ConfigurationNextInstall the Code

Last updated 2 years ago

✳️