I use piwik to track an high traffic website and the infrastructure is composed by EC2 instances and a RDS instance.
Everything works fine except an error I get in “Database abilities”
LOAD DATA INFILE Using LOAD DATA INFILE will greatly speed Piwik's archiving process up. To make it available to Piwik, try updating your PHP & MySQL software and make sure your database user has the FILE privilege. If your Piwik server tracks high traffic websites (eg. > 100,000 pages per month), we recommend to try fix this problem. Error: LOAD DATA INFILE failed... Error was: Try #1: LOAD DATA INFILE : SQLSTATE: Invalid authorization specification: 1045 Access denied for user 'tamcdrupal'@'%' (using password: YES), Try #2: LOAD DATA LOCAL INFILE : SQLSTATE: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version
Are there some best practices to avoid this error, using Piwik and RDS?