Kayako logo
Technical Chat From server configurations to local area networking - the technical discussion forum.

Kayako develops robust helpdesk software, live chat and real-time visitor monitoring software.
Kayako is trusted by more than 30,000 organizations, including a number of Fortune 500 companies and government institutions.
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  (#1) Old
Dynadata Offline
Member
 
Posts: 171
Join Date: Feb 2008
Location: Netherlands
MySQL user privileges - 01-04-2008, 02:43 PM

By installing Kayako you'll need to make an extra MySQL user which must have all rights.
But what if the installation is done? What rights does Kayako need?
I think the following actions can be allowed for the MySQL user which will use Kayako database:
Code:
SELECT
INSERT
UPDATE
DELETE
But I think the following actions could be denied for the MySQL user which will use Kayako database:
Code:
CREATE
DROP
GRANT
REFERENCES
INDEX
ALTER
CREATE_TMP_TABLE
LOCK_TABLES
CREATE_VIEW
SHOW_VIEW
CREATE_ROUTINE
ALTER_ROUTINE
EXECUTE
Am I correct?
   
Reply With Quote
  (#2) Old
Jamie Edwards Offline
Operations Manager
 
Jamie Edwards's Avatar
 
Posts: 7,373
Join Date: Jan 2006
Location: England, UK
01-04-2008, 02:52 PM

The upgrade script may need access to CREATE, ALTER and possibly INDEX in the future.


Jamie Edwards (jamie.edwards ]at[ kayako.com)
----------------------------------------------------------------
---
   
Reply With Quote
  (#3) Old
Dynadata Offline
Member
 
Posts: 171
Join Date: Feb 2008
Location: Netherlands
01-04-2008, 02:58 PM

Ok so if I would give my user the following privileges it should work without any problems?
Code:
SELECT
INSERT
UPDATE
DELETE
CREATE
ALTER
INDEX
   
Reply With Quote
Reply

Tags
mysql, privileges

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
User groups hierarchy gdigrego End-user related misc 0 16-03-2008 02:09 PM
Associating more than one User Group to a template group Aaron Templating and themes 0 12-03-2008 08:48 PM
Free External login PHP guide Siora Modifications & Extensions 27 11-02-2008 06:28 AM
[HOW TO] Get the Winapp client runing on Terminal Servers Paul Agerbeek LiveResponse Desktop Application 0 12-10-2006 11:34 AM



Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78