Re: Create Temporary Table

The IP address CAN change, but doesn't change on such a basis that it would cause a problem. You see the issue also appears whether I am user@localhost or user@10.1.1.1 it doesn't matter where I am coming from. Thx ----- Original Message ----- From: "Stephen March" <steve@enerds.ca> To: "Phil Dowson" <dowson@mchsi.com> Cc: <mysql@lists.mysql.com>; <php-db@lists.php.net> Sent: Sunday, July 06, 2003 2:29 am Subject: Re: [PHP-DB] Create Temporary Table > Does the ip address of where you are trying to access the mysql database > from (client), change? If you have a dynamic ip address > your ISP should have a grant something to the effect of: > > grant all on database.* to user@10.1% identified by 'password'; > > This would allow your client to be any address on the 10.1.X.X network. > You can just grant access to the database to user@% if you want that > user to be able to access the database from any ip address. This might > have some security implications for you, if it's wide open on the > Internet. That's the only reason I can think for intermittent problems. > > Cheers, > ~Steve > > Phil Dowson wrote: > > >Hi, > > > >PHP Version 4.3.1 > >Mysql Version 4.0.13 > > > >When I try and run the following query > > > >CREATE TEMPORARY TABLE temptable AS SELECT * FROM permtable; > > > >on each database, the first one will run it with no problems at all. The > >second returns the error: > > > >[server] ERROR 1044: Access denied for user: 'user@10.1.1.1%' to database > >'database' > > > >I have tried running the same query from MySQL at my site, from via the PHP > >interface I am working with and also via PHPMyAdmin, each returns the same > >error. > > > >One thing I should note. The CREATE TEMPORARY TABLE syntax does not work, > >however if I were to use the CREATE TABLE syntax, it works fine. But I'd > >rather use the TEMPORARY tables. > > > >This problem appears to be intermittent, it will work fine for a few days, > >then fail for an undetermined amount of time. I have checked with my ISP, > >they are sure that the rights haven't changed, and I have CREATE TEMPORARY > >TABLE rights. > > > >Any ideas why this is intermittent? > > > >Thanks for your help! > > > >Phil Dowson > > > > > > > > > > > > > >