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 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 time all other sql requests work correctly. How can I > handle this? Please help. > > _______________________________________________________________ > йНППЕЯОНМДЕМр фСПМЮК МНБНИ ЩОНУХ сЙПЮХМШ > http://www.korrespondent.net/zhurnal > > -- > 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]