In this video you will find me configuring help desk using open source program called "Hesk".
SQL Scripts used in video
CREATE DATABASE `hesk`
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'hesk-owner'@'localhost';
CREATE USER 'hesk-owner'@'127.0.0.1';
CREATE USER 'hesk-owner'@'::1';
SET PASSWORD
FOR 'hesk-owner'@'localhost' = PASSWORD('hesk123$%');
SET PASSWORD
FOR 'hesk-owner'@'127.0.0.1' = PASSWORD('hesk123$%');
SET PASSWORD
FOR 'hesk-owner'@'::1' = PASSWORD('hesk123$%');
GRANT ALL PRIVILEGES ON
`hesk`.* TO 'hesk-owner'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON
`hesk`.* TO 'hesk-owner'@'127.0.0.1' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON
`hesk`.* TO 'hesk-owner'@'::1' WITH GRANT OPTION;