RE: [PHP-DB] MySql Help needed
| From: | Peter Lovatt | Date: | Sun, 30 Mar 2003 08:51:45 +0000 |
| Subject: | RE: [PHP-DB] MySql Help needed | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26715@lists.php.net to get a copy of this message | ||
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: [PHP-DB] 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