I am unable to install Piwik at the moment. I receive the following error message " SQLSTATE[HY000]  mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. "
I had just uninstalled my previous version in order to upgrade (it told me that it was up to date, but I saw much more recent versions out there, perhaps I was at the latest for my configuration) and deleted the database as I didn’t have data I needed.
I spoke to iXWebhosting who tell me that the MySQL version cannot be upgraded on shared hosting and there is no way forward for me.
Q My question therefore is what previous version of Piwik do I need to avoid the newer authentication and mysqlnd. can work with this until I get a better hosting, or IX Webhosting update their software