[arch-general] php / mysql connection after recent update

[Chris Allison]

On 11 March 2010 10:30, Chris Allison
<chris.charles.allison at googlemail.com> wrote:
>
>
> On 11 March 2010 10:23, Chris Allison <chris.charles.allison at googlemail.com> wrote:
>>
>> Morning,
>>
>> Since updating yesterday, all my php scripts that connect to a mysql database (whether local or over the network) stopped being able to connect.  I had to append the port number to the host definition in the mysql connect function call to get them to work again.  I have been unable to find what has changed.  Any ideas where the change may have happened.
>>
>> thanks
>>
>> Chris Allison
>>
>
> Hi,
>
> Digging a bit deeper, the php.ini directive mysql_default_port is not set, though it has never been set in my php.ini.  setting that to 3306 solved the problem.
>
> Sorry for the noise.
>
> Cheers
>
> Chris


Hi,

This would appear to be an upstream bug/feature. from the
mysql_connect doc page comments:


"The php.ini file suggests that PHP will select the port by using the
$MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services, but in this
case it is not so.  /etc/services on my machine has 3306 listed, but
it didn't get picked up."

cheers

Chris