Getting Started

Installing MySql

• Open Solution Explorer
• Select Hardly.Library.Sql
• Right click references -> Manage NuGet packages
• Install MySql.Data

DBSchema.txt

Use this to create your tables in MySql.

• Open MySql Workbench
• Create a new schema
• Double click that schema (turn bold)
• Open new Sql, paste contents and run.

SAMPLE_Place_in_bin_dir-UidAndPwd.txt

Edit this as appropriate for your MySql connection. Put a copy in the bin directory of your main application (e.g. TwitchChatBotConsole\TwitchChatBotConsole\bin\Debug\UidAndPwd.txt).

Server=10.0.1.9;Database=sobercode;Uid=soberCode;Pwd=password;

• Server=your server ip (likely 127.0.0.1)
• Database=the name of the schema you created (anything is fine)
• Uid=the user you log into Sql with (I recommend you don't use root, but that would work)
• Pwd=user's password

Data Requirements In order to start the Twitch bot, you must at least have entries in a few tables. See Hardly.Library.Sql\PreBuild_DataPopulation_Tables.txt