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]