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' 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]