Server Requirements

The helpdesk does not currently run on versions of MySQL greater than 4.x. Best results will be found by using mysql-server 4.1.x.

Creating databases

• helpdesk      (helpdesk core, call tracking module)
• Modules
  • inventory   
  • kb
  • calendar     

create database helpdesk;
create database inventory;
create database kb;
create database calendar;

User privileges

• You should be familiar with MySQL user account management before setting all this up.
• You need one user or multiple users that have at least read/write and locking privs to these databases. You don't have to use the same user for all, so you can have it granular if you want.
• Granting too many privileges or using wildcards on host restrictions might be a bad idea, so keep this all in mind.

  GRANT ALL PRIVILEGES ON helpdesk.* TO 'helpdesk'@'localhost' IDENTIFIED BY 'some_pass';
  GRANT ALL PRIVILEGES ON helpdesk.* TO 'inventory'@'localhost' IDENTIFIED BY 'some_pass';
  GRANT ALL PRIVILEGES ON helpdesk.* TO 'kb'@'localhost' IDENTIFIED BY 'some_pass';
  GRANT ALL PRIVILEGES ON helpdesk.* TO 'calendar'@'localhost' IDENTIFIED BY 'some_pass';

• Here localhost would be your database server. Usernames and passwords are up to you as well.