RE: MySql Help needed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux