Howto change default MySQL privileges/permissions in Confixx

Written by Claudio Kuenzler - 0 comments

Published on May 24th 2011 - Listed in Linux Internet Database MySQL

If Confixx creates a new MySQL user, the default privileges are the following:

SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES

Now what if a user wants to use the INDEX command? The server will deny the command because of missing permissions. The privileges can either be manually adjusted in the mysql database or, and this is more interesting, it can be globally changed for all new MySQL users!

The file to change (class.MysqlPermissions.php ) can be found in your Confixx html folder, e.g. /srv/www/confixx/html/include/class.MysqlPermissions.php. On line 197 you have the following text:

new MysqlPermission( 'Index_priv', 'N', 0 ),

Change this to Y:

new MysqlPermission( 'Index_priv', 'Y', 0 ),

And you're good. From now on new MySQL users created by Confixx will have the Index privilege.

Update July 29th, 2011: I just saw, that the INDEX permissions are now set by default since Confixx 3.3.7.

Add a comment

Comments (newest first)

No comments yet.