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 [EMAIL PROTECTED] identified by 'password';
This would allow your client to be a
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: '[EMAIL