PHP :: Request #70955 :: bind mysql client connection to specific ip

bind mysql client connection to specific ip

Submitted:

2015-11-22 16:32 UTC

Modified:

2016-11-23 13:40 UTC

Votes:	1
Avg. Score:	3.0 ± 0.0
Reproduced:	0 of 0 (0.0%)

From:

theultramage at gmail dot com

Assigned:

mysql (profile)

Status:

Assigned

Package:

MySQLi related

PHP Version:

5.6.15

OS:

Private report:

CVE-ID:

None

View Developer Edit

[2015-11-22 16:32 UTC] theultramage at gmail dot com

Description:
------------
Libmysql documentation mentions that mysql_options(MYSQL_OPT_BIND, "hostname_or_ipaddress") exists since MySQL 5.6.1 (2011). This solves the problem of connecting from a host with multiple IPs, because otherwise the host's current default interface is used; this is decided by the operating system and it may change over time. MySQL server is especially sensitive to this since logins are tied to IP addresses.

PHP's mysql, mysqli and pdo_mysql interfaces don't seem to expose this functionality.

Patches

Pull Requests

Pull requests:

protect master branches except for the pecl repos against force pushes (karma/4)
Very need, touch method (pecl-caching-memcache/1)
error message should matched path (pecl-database-pdo_informix/1)
Add support for bitwise string assign ops (php-src/1322)

History

AllCommentsChangesGit/SVN commitsRelated reports

[2015-11-24 05:49 UTC] laruence@php.net

-Assigned To: +Assigned To: mysql

[2015-11-24 05:49 UTC] laruence@php.net

it's better also have mysqlnd's supports, assign to mysql team , thanks

[2016-11-23 13:40 UTC] cmb@php.net

-Package: MySQL related +Package: MySQLi related

	php.net \| support \| documentation \| report a bug \| advanced search \| search howto \| statistics \| random bug \| login
go to bug id or search bugs for


Copyright © 2001-2024 The PHP Group All rights reserved.	Last updated: Thu Nov 21 11:01:29 2024 UTC