Request for database rights

[EdwardHamHam]

Temporary tables are not supported. If you need to store temporary data, you can do so by holding it in PHP.

Access issues

I’m not saying you can’t do it, you just need to adapt your code to not use the temporary tables. If you need to store temporary data you can do so on InfinityFree by holding it in PHP, but from your description, it sounds to me like you need to hold it for long periods. Your best bet is to create a database and table yourself through phpMyAdmin, then write your code to insert data into that table. Take a look at this guide for more detailed instructions.