RE: Problem with Temporary Table

2003-07-10 Thread Uttam
: Problem with Temporary Table Didier ROS [EMAIL PROTECTED] wrote: I am a newbie I want to create a temporary table and I get the following error message : mysql CREATE TEMPORARY TABLE tempemp AS SELECT * FROM emp; ERROR 1044: Access denied for user: '@localhost' to database 'test1

Re: Problem with Temporary Table

2003-07-09 Thread Egor Egorov
Didier ROS [EMAIL PROTECTED] wrote: I am a newbie I want to create a temporary table and I get the following error message : mysql CREATE TEMPORARY TABLE tempemp AS SELECT * FROM emp; ERROR 1044: Access denied for user: '@localhost' to database 'test1' You must have CREATE

RE: Problem using TEMPORARY TABLE

2003-07-03 Thread csebe
It's probably a matter of granting CREATE TEMPORARY TABLE privilege for the hardware user. HTH, Lian -Original Message- From: Andrey Mishenin [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 8:26 PM To: [EMAIL PROTECTED] Subject: Problem using TEMPORARY TABLE I've got a

Re: Problem using TEMPORARY TABLE

2003-07-03 Thread Victoria Reznichenko
Andrey Mishenin [EMAIL PROTECTED] wrote: I've got a problem using temporary tables. Tring to make one (mysql CREATE TEMPORARY TABLE ... ) I recieve an error message: ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'hardware' At the mean