From: Mike M. <mm...@ad...> - 2003-03-07 15:52:41
|
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', you...@yo...', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1) ----- Original Message ----- From: Corey Duncan To: php...@li... 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 yet. I thought the line: grant all privileges on phphelpdesk.* to phphdadmin@localhost 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? |