Re: [PHP] mysql_connect noob question

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>')
>>
>> Thanks,
>>
>> On 4/19/13 3:28 PM, tamouse mailing lists wrote:
>>> On Fri, Apr 19, 2013 at 3:43 PM, Glob Design Info <[email protected]>
>>> wrote:
>>>> 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 those
>>>> 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.
>>>>
>>>> Thanks,
>>>>
>>>> --
>>>> 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 for
> '<user>'.
>
> 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'.
>