Hi, PHP Version 4.3.1 Mysql Version 4.0.13 When I try and run the following query CREATE TEMPORARY TABLE temptable AS SELECT * FROM permtable; on each database, the first one will run it with no problems at all. The second returns the error: [server] ERROR 1044: Access denied for user: 'user@10.1.1.1%' to database 'database' I have tried running the same query from MySQL at my site, from via the PHP interface I am working with and also via PHPMyAdmin, each returns the same error. One thing I should note. The CREATE TEMPORARY TABLE syntax does not work, however if I were to use the CREATE TABLE syntax, it works fine. But I'd rather use the TEMPORARY tables. This problem appears to be intermittent, it will work fine for a few days, then fail for an undetermined amount of time. I have checked with my ISP, they are sure that the rights haven't changed, and I have CREATE TEMPORARY TABLE rights. Any ideas why this is intermittent? Thanks for your help! Phil Dowson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
