Hi
Try running a grant query
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER
ON database_name.*
TO myname@PHP_MAIN
IDENTIFIED BY 'mypassword';
which will probably fix it
Peter
-----Original Message-----
From: Sparky Kopetzky [mailto:sparkyk@blackmesa-isp.net]
Sent: 30 March 2003 04:12
To: php-db@lists.php.net
Subject: MySql Help needed
Greetings!
I am building an application in PHP and am creating a global $connect_id for
MySql. I have MySql on a separate machine and am using the connect like
this:
$server = "development.myservermachine.net";
$username = "myname";
$password = "mypassword";
$connect_id = mysql_connect($server, $username, $password);
All I get is 'Access denied for user 'myname@PHP_MAIN' (Using password:YES)
Now, I know I'm in the DNS server for my system, and the username and
password are correct as I checked the User table.
Any thoughts, ideas, etc. toward fixing this problem??
I'd appreciate any help provided.
Robin Kopetzky
Black Mesa Computer/Internet Services
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
