List:General Discussion« Previous MessageNext Message »
From:Russell R Snella Date:July 23 2003 4:57pm
Subject:Create Temporary Table
View as plain text  
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: 'russ@stripped' 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


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


Thank you, for you help in advance.



Russell R. Snella


Create Temporary TableRussell R Snella23 Jul
  • Re: Create Temporary TablePhil Bitis24 Jul