Very good question, I believe I do since it does work 90% of the time. Only occasionally it doesnt work, and thats why I need help
----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Phil Dowson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, June 28, 2003 4:50 pm Subject: Re: Temporary Table Issues > At 16:47 -0500 6/28/03, Phil Dowson wrote: > >Hi, > > > >I am experiencing a problem creating temporary tables within a MySQL > >database. When I run the following query: > > > >CREATE TEMPORARY TABLE IF NOT EXISTS rmb AS SELECT * FROM rmmt GROUP BY > >rmmtid; > >drop table rmb > > > >I get the error > > > >[server] ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database > >'database' > > Do you have the CREATE TEMPORARY TABLES privilege? > > > > >Now this should indicate a username/password/permissions problem, but when I > >use the query: > > > >CREATE TABLE IF NOT EXISTS rmb AS SELECT * FROM rmmt GROUP BY rmmtid; > > > >I get no error. > > > >Here is the part where I am losing my mind. I had the same issue about 3 or > >4 days ago, I checked with my service provider and they said the host was > >working fine. And it still didn't work. Just as I was composing an email to > >this list it started working again, like magic. Well now its happened again > >and I'm at a loss as to the reason why it doesn't work. > > > >I am trying to use the database either from the localhost or from a remote > >IP and have the same problem. I have plenty of disk space allocated to me. > > > >The version of MySQL is 4.013, it is running on a Linux OS Kernel version > >2.4.20-18.7, I am pretty sure its Redhat 7.2, I can find out if its > >relevant. > > > >Hope someone can help. > > > >Phil Dowson > >=== > >[EMAIL PROTECTED] > > > -- > Paul DuBois, Senior Technical Writer > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > Are you MySQL certified? http://www.mysql.com/certification/ > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
