Header RSS Feed
 
If you only want to see the articles of a certain category, please click on the desired category below:
ALL Android Backup BSD Database Hacks Hardware Internet Linux Mail MySQL Monitoring Network Personal PHP Proxy Shell Solaris Unix Virtualization VMware Windows Wyse

Howto change default MySQL privileges/permissions in Confixx
Tuesday - May 24th 2011 - by - (0 comments)

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

Show form to leave a comment

Comments (newest first):

No comments yet.

Go to Homepage home
Linux Howtos how to's
Nagios Plugins nagios plugins
Links links

Valid HTML 4.01 Transitional
Valid CSS!
[Valid RSS]

7633 Days
until Death of Computers
Why?