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.
No comments yet.
AWS Android Ansible Apache Apple Atlassian BSD Backup Bash Bluecoat CMS Chef Cloud Coding Consul Containers CouchDB DB DNS Database Databases Docker ELK Elasticsearch Filebeat FreeBSD Galera Git GlusterFS Grafana Graphics HAProxy HTML Hacks Hardware Icinga Icingaweb Icingaweb2 Influx Internet Java KVM Kibana Kodi Kubernetes LVM LXC Linux Logstash Mac Macintosh Mail MariaDB Minio MongoDB Monitoring Multimedia MySQL NFS Nagios Network Nginx OSSEC OTRS Office PGSQL PHP Perl Personal PostgreSQL Postgres PowerDNS Proxmox Proxy Python Rancher Rant Redis Roundcube SSL Samba Seafile Security Shell SmartOS Solaris Surveillance Systemd TLS Tomcat Ubuntu Unix VMWare VMware Varnish Virtualization Windows Wireless Wordpress Wyse ZFS Zoneminder