Req #70955 [NEW]: bind mysql client connection to specific ip
| From: | theultramage at gmail dot com | Date: | Sun, 22 Nov 2015 16:32:42 +0000 |
| Subject: | Req #70955 [NEW]: bind mysql client connection to specific ip | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-197367@lists.php.net to get a copy of this message | ||
From: theultramage at gmail dot com
Operating system:
PHP version: 5.6.15
Package: MySQL related
Bug Type: Feature/Change Request
Bug description:bind mysql client connection to specific ip
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 bug report at https://bugs.php.net/bug.php?id=70955&edit=1
--
Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=70955&r=trysnapshot54
Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=70955&r=trysnapshot55
Try a snapshot (trunk): https://bugs.php.net/fix.php?id=70955&r=trysnapshottrunk
Fixed in SVN: https://bugs.php.net/fix.php?id=70955&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=70955&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=70955&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=70955&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=70955&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=70955&r=support
Expected behavior: https://bugs.php.net/fix.php?id=70955&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=70955&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=70955&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=70955&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=70955&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=70955&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=70955&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=70955&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=70955&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=70955&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=70955&r=mysqlcfg