Create Temporary Table

[Russell R Snella]

Hello,
 
Mysql Version 4.0.11a-gamma
 
When I try and run the following query
 

create temporary table russ1 as 

select rcust.* 

from rcust;

 
and I receive the error message:

Error Code : 1044

Access denied for user: '[EMAIL PROTECTED]' to database 'customer'

(0 ms taken)

 

I can run the query from the command line of the server and the query
works correctly.
 
I have run the query GRANT ALL PRIVILEGES ON customer.* TO
[EMAIL PROTECTED]

 

In addition, I flushed the privileges, and I stopped and restarted the
database.

 

Thank you, for you help in advance.

 

 

Russell R. Snella