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

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: 5,033
Join Date: Jan 2006
Location: United Kingdom
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)
----------------------------------------------------------------
---
  • New to the forum? New user's guide here.
  • Submit bug reports here.
  • Submit support tickets via the members area.
  • Submit sales queries either via live chat or via e-mail.
  • There is no official ETA on Version 4.
   
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
Users User groups hierarchy gdigrego Feature Requests 0 16-03-2008 02:09 PM
Templates/Themes Associating more than one User Group to a template group Aaron Feature Requests 0 12-03-2008 08:48 PM
Free External login PHP guide Siora Modifications & Addon Releases 27 11-02-2008 07: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.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
vBulletin Skin developed by: vBStyles.com


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