For the following I am assuming you didn't edit that output for security
reasons.  What I see immediately wrong is that you are not passing a
username to mysql (If you were, then there would be something like
'[EMAIL PROTECTED]' there).  Of course you can set MySQL up so that it does
not require a username to connect, but that isn't very secure.

-Rob

-----Original Message-----
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 3:43 AM
To: [EMAIL PROTECTED]
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]

Reply via email to