Re: Re: mysql_connect noob question

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

 



As shown in the OP I am already doing that in the PHP scipt:

$host = "instance43490.db.xeround.com:8904";

And then passing that as the 1st param to mysql_connect

On 4/21/13 4:23 PM, Stuart Dallas wrote:
On 22 Apr 2013, at 00:14, Glob Design Info <info@xxxxxxxxxxxxxx> wrote:

However, I may have found the problem: the port. As a security measure the BaaS provider appears to have changed MySQL to a non-standard port. So............

On the command line:

sudo mysql --host=instance43490.db.xeround.com --port=8904 --user=<realuser> --password=<realpass>

WORKS perfectly - entering the MySQL Monitor.

However, on the same host, same command line:

sudo mysql --host=instance43490.db.xeround.com:8904 --user=<realuser> --password=<realpass>
The MySQL command line doesn't support putting the port number there, but the first parameter of mysql_connect does. If this is the problem then it cannot be true that replacing the variables you were taking from $_POST with literal strings for the username and password worked, as I asked earlier to which you said it does.

Replace the first parameter to your mysql_connect call with 'instance43490.db.xeround.com:8904' and it will probably work.

-Stuart



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





[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux