On 4/19/2013 9:33 PM, Glob Design Info wrote:
They aren't on the same server. The DB is on xeround.com, the web server
is localhost.

The host value is set and working. If I hard-code the user and password
values in the mysql_connect() call and leave the host value as is, it
connects fine. Only passing the user and password from the form cause it
to fail.

On 4/19/13 5:47 PM, David Robley wrote:
Glob Design Info wrote:

Sorry. The error displayed is:

*Warning*: mysql_connect() [function.mysql-connect
<http://localhost/wservices/function.mysql-connect>]: Access denied for
user '<user>'@'ip70-162-142-180.ph.ph.cox.net' (using password: YES) in
*/Library/WebServer/Documents/wservices/connect.php* on line *29*

(But with the real user name, not just '<user>')


On 4/19/13 3:28 PM, tamouse mailing lists wrote:
On Fri, Apr 19, 2013 at 3:43 PM, Glob Design Info <i...@globdesign.com>
I know this has probably been answered already.

When I pass a user name and password from a form to my PHP script and
then pass those to mysql_connect it doesn't connect. When I paste
exact same values into mysql_connect as string literals it works.

Can anyone tell me why this happens?

I know the strings are identical to the literals I try in a test but
they don't work when submitted via form.

$form_user = $_POST[ 'user' ];
$form_pass = $_POST[ 'password' ];

# Connect to remote DB

$LINK = mysql_connect( $host, $form_user, $form_pass );

Please show the error you are getting from the mysql_connect

And yes, my $host param is correct.


PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

First guess is that you don't have privileges for
'<user>'@'ip70-162-142-180.ph.ph.cox.net', but you may have privileges

And, what are you using for the $host value? If the script and mysql
are on
the same server, it shouldn't need to be anything other than 'localhost'.

Do your user or password contain spaces, thereby requiring quotes in your call?

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to