Create temporary table

Hello everyone, I just moved a webapp (developed in php and mysql) from my old server to ProFreeHost.
I noticed I get and error when I create a temporary table, it seems like my user doesn't have the permission to create it.
I execute the same query in the SQL panel of phpMyAdmin and I get the same risult:

1044 - Access denied for user 'MYUSERNAME'@'192.168.0.%' to database 'MYDATABASE'

This is the query:

CREATE TEMPORARY TABLE TempTable AS (SELECT * FROM Memorandum WHERE stato_memo=0) ORDER BY data_scadenza_memo DESC

Can anyone help me?

Thank you very much.


  • Unfortunately, temporary tables privilege is not granted due to the overload that can be created.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion