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.
It looks like you're new here. If you want to get involved, click one of these buttons!