For what it's worth, I get the same problem with 4.0.13, and have posted the same question a few times with no response. It works fine at the command line, but not through the mysql++ API. It doesn't work on my home/work machines (both running XP), though my colleague doesn't experience the problem at all even though he's using 4.0.13 on 2000/XP.
----- Original Message ----- From: "Russell R Snella" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 23, 2003 5:57 PM Subject: Create Temporary Table > 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 > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]