Unable to install - Plugin cannot create Temp Table

[RareMagic]

Hi,

I am trying to install CiviCRM but the install fails on validation, from Can't create Temp Table downwards. Connection to the database is fine and when logging into the database as the user specified in CiviCRM I can create tables and have full access to the database. Can anybody help with this?

Thank you.

[Hershel]

 The CREATE TEMPORARY TABLES privilege is not the as the CREATE privilege, which enables creation of new databases and tables.

[RareMagic]

Thank you Hershel, that could well be the problem, my host excludes the CREATE TEMPORARY TABLES by default.