> For the complete documentation index, see [llms.txt](https://miftycoin.gitbook.io/miftycoin-broker-node-configuration/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://miftycoin.gitbook.io/miftycoin-broker-node-configuration/setup/setup-the-database.md).

# 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;

```