I granted all possible priviledges to my DB using Zymic DB Management console.
But, looks like I have no permission for TEMPORARY TABLE creation in my DB.
All other tables are created successfully.
The TEMPORARY TABLE creation results in Error 1044 : Access Denied.
The SQL syntax is correct because it works on my other hosting.
So, the question: How can I enable creation of TEMPORARY TABLES in my DB?