I just downloaded Piwik and began the install process. My server passed the System Check with flying colors, but failed on the Database Setup. Below is the message it gives just one second after I click the Next button—
Test SQL failed to execute: CREATE TEMPORARY TABLE piwik_test_table_temp ( id INT AUTO_INCREMENT, PRIMARY KEY (id) )Error: SQLSTATE[HY000]: General error: 1005 Can’t create table ‘piwik_test_table_temp’ (errno: 13)
I host eleven websites with 1and1.com, and really like their service. I created the database on the 1and1 server, and after the ‘SQL failed’ message logged back in and saw that 15 tables had been created, but not one for ‘piwik_test_table_temp’. Not sure what would cause the failure.
I would really like to get Piwik installed and working. Does anyone else host with 1and1 and has been able to get Piwik working? I’ve tried v2.11.2 and v2.12.1, and both fail with the same message. Any help would be greatly appreciated.