sql_plugin.txt

git clone https://github.com/NebulaProtocol/eos.git --recursive
cd eos
git checkout sql_plugin
git submodule update --init --recursive
apt-get update
apt-get install mysql-server libsoci-dev
./eosio_build.sh -s EOS
cd build
make install

mkdir ../../boot
cd ../../boot
wget https://gist.github.com/kesar/8ba0e07b247f5d235a1fe11a21ce02f0
wget https://gist.github.com/kesar/a820069a016f62facc73d8932cadc42f

mysql -u root -p

create database eos;
ALTER DATABASE eos CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

nohup nodeos --plugin eosio::chain_api_plugin --p2p-peer-address p2p.eos42.io:9876 --p2p-peer-address api.tokenika.io:9876 --plugin eosio::sql_db_plugin --sql_db-uri="mysql://db=eos user=root password=tu_password host=127.0.0.1" --genesis-json genesis.json --config-dir . --data-dir . --blocks-dir blocks --max-irreversible-block-age 432000000 --delete-all-blocks --http-server-address=127.0.0.1:8889 > out.txt &


socat tcp-listen:8001,reuseaddr,fork tcp:localhost:3306