Here is the mySQL data from my admin account (with a few edits of course).
This is in the security table:
basically a '1' in every permission field.
INSERT INTO security (s_user, s_firstname, s_lastname, s_password,
s_timestamp_laston, s_email, s_register_new_tickets, s_authorize_tickets,
s_assign_tickets, s_update_tickets, s_delete_tickets, s_open_closed_tickets,
s_view_unauthorized_tickets, s_view_department_tickets, s_add_categories,
s_delete_categories, s_add_departments, s_delete_departments,
s_manage_users, s_pref_viewall, s_add_parts, s_isroot,
s_pref_viewjobs_first, s_generate_reports, s_ismanager)
VALUES('admin', 'Firstname', 'Lastname', 'password', '2003-03-06 12:57:00',
yourname@...', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
1, 1, 1)
----- Original Message -----
From: Corey Duncan
Sent: Friday, March 07, 2003 6:35 AM
Subject: [Phphelpdesk-help] I don't have permission to add users
I ran the phphelpdesk.sql and all went well, when I access the site it lets
me in, but when I try add anything it says I don't have permission. This is
loging in with the default admin/admin account, as I'm unable to change it
I thought the line: grant all privileges on phphelpdesk.* to
phphdadmin@... identified by 'phphdpassword'; but now wonder if that'
s generic and I needed to edit it? Can any help clarify this?
Also, where do I get to set the language options for a user?