Req #70955 [Opn]: bind mysql client connection to specific ip

Edit report at https://bugs.php.net/bug.php?id=70955&edit=1 ID: 70955 Updated by: laruence@php.net Reported by: theultramage at gmail dot com Summary: bind mysql client connection to specific ip Status: Open Type: Feature/Change Request Package: MySQL related PHP Version: 5.6.15 -Assigned To: +Assigned To: mysql Block user comment: N Private report: N New Comment: it's better also have mysqlnd's supports, assign to mysql team , thanks Previous Comments: ------------------------------------------------------------------------ [2015-11-22 16:32:41] 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. ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=70955&edit=1