Database Setup

Using MySQL as our database engine.


Download and install MySQL from

If you need a GUI you can download and install MySQL Workbench from


Login to MySQL

We'll open a command prompt and issue the following command:

mysql -u root -p -h

Create the database

mysql> CREATE DATABASE mybot;
Query OK, 1 row affected (0.07 sec)

Create the user

mysql> GRANT ALL PRIVILEGES ON mybot.* TO 'mybotuser'@'localhost' IDENTIFIED BY 'mybotpassword';
Query OK, 0 rows affected, 2 warnings (0.07 sec)

After starting our bot for the first time the table schemas will be created automatically for us so there are no tables to create at this time.