From the prompt, cd into the WebGoat.NET DB directory
% cd /WebGoat.NET/DB_Scripts
Start the mysql utility, giving the name (and password, if needed) of a user permission to create databases. For example, to use the default root user:
% mysql --user=root
Create the webgoat_coins database and load the schema. (Loading the schema the schema the first time will give error messages as it attemps to empty any existing tables, just ignore these.)
mysql> create database webgoat_coins;
mysql> use webgoat_coins;
mysql> source create_webgoatcoins.sql;
Load the table contents:
mysql> source load_webgoatcoins.sql;
Exit from mysql:
mysql> quit;
PM> Install-Package MySql.Data
File: C:\Users\xxxx\source\repos\WebGoat.NET\WebGoat\Configuration\Default.config
dbtype=MySql
filename=C:\ProgramData\MySQL\MySQL Server 5.7\Data\
client=C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe
pwd=xxxx
uid=xxxx
database=webgoat_coins
port=3306
host=localhost