I've been having the same problem, using mysql++ with mysql 4.0.13. It works just fine entered into mysql-front or mysql.exe, but not through mysql++ Can I check the CREATE TEMPORARY TABLES privilege through the API?
----- Original Message ----- From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 16, 2003 8:43 AM Subject: Re: More duhh! questions > "Degan, George E, JR, MGSVC" <[EMAIL PROTECTED]> wrote: > > I am attempting to create a temporary table to do a complex query and I get an error: > > error 1044: Access denied for user: '@localhost' to database 'shopsample' > > what can I do to keep this from happening? I am using the production version of mySQL 4.0.13 in windows 2000. > > Does user have CREATE TEMPORARY TABLES privilege? > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
