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.
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Comments
Unfortunately, temporary tables privilege is not granted due to the overload that can be created.