Copy [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
Copy $ systemctl restart mysqld
Copy $ wget http://bnd001.miftycoin.com/api/dump?clearexcludes=true -O dump.sql
$ wget http://bnd001.miftycoin.com/api/schema -O schema.sql
Copy 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;