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: '[EMAIL PROTECTED]' to 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
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
Any ideas why this is intermittent?
Thanks for your help!
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php