No, no spaces. I am wondering if I need to use htmlspecialchars() On Apr 19, 2013, at 7:17 PM, Jim Giner <jim.giner@xxxxxxxxxxxxxxxxxx> wrote: > 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>') >>>> >>>> Thanks, >>>> >>>> On 4/19/13 3:28 PM, tamouse mailing lists wrote: >>>>> On Fri, Apr 19, 2013 at 3:43 PM, Glob Design Info <info@xxxxxxxxxxxxxx> >>>>> 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'. >>> > 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 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
