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

 

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

 

Thank you, for you help in advance.

 

 

Russell R. Snella

 


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