I updated my piwik 1.7 to 1.8
I have 10 website 10 piwik.
Main website stats showning normal.
But if i select another website from right top area combobox, it gives error.
Error details :
SQLSTATE: Syntax error or access violation: 1044 Access denied for user ‘myusername’@’%’ to database ‘mydatabasename’
It said that, access denied but i can access to panel via my username and password. And i can see details of default selected website. Only when i changed website to see details, it gives error. Everything on same database.