Add support for mysql named pipe (windows os)

[bogdan.ionescu]

This patch allows the connection via pipe into the windows operating system.

Configuration needed:

MySQL 5.6 file: my.ini

[mysqld]

#
# ... other settings here ...
#

skip-networking
enable-named-pipe
socket="mysql56.pipe"

[client]

#
# ... other settings here ...
#

pipe
socket="mysql56.pipe"

Wordpress file: wp-config.php

<?php
#
# ... other settings here ...
#

/** The name of the database for WordPress */
define('DB_NAME', 'wp_demo1');

/** MySQL database username */
define('DB_USER', 'wp_demo1');

/** MySQL database password */
define('DB_PASSWORD', 'pa$$w0rd');

/** MySQL hostname */
define('DB_HOST', '.:\\\\.\\pipe\\mysql56.pipe'); # syntax = ".:\\.\pipe\name.pipe"

/** MySQLi extension (optional) */
#define('WP_USE_EXT_MYSQL', false); # for mysqli set to false

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', 'utf8_general_ci');

Wordpress patch: wp-db.php

src/wp-includes/wp-db.php

@@ -1414 +1414 @@
                  * Deprecated in 3.9+ when using MySQLi. No equivalent
                  * $new_link parameter exists for mysqli_* functions.
                  */
                 $new_link = defined( 'MYSQL_NEW_LINK' ) ? MYSQL_NEW_LINK : true;
                 $client_flags = defined( 'MYSQL_CLIENT_FLAGS' ) ? MYSQL_CLIENT_FLAGS : 0;
+                $port = null;
+                $socket = null;
+                $host = $this->dbhost;
+                $port_or_socket = strstr( $host, ':' );
 
                 if ( $this->use_mysqli ) {
                         $this->dbh = mysqli_init();
 
                         // mysqli_real_connect doesn't support the host param including a port or socket
                         // like mysql_connect does. This duplicates how mysql_connect detects a port and/or socket file.
-                        $port = null;
-                        $socket = null;
-                        $host = $this->dbhost;
-                        $port_or_socket = strstr( $host, ':' );
                         if ( ! empty( $port_or_socket ) ) {
                                 $host = substr( $host, 0, strpos( $host, ':' ) );
                                 $port_or_socket = substr( $port_or_socket, 1 );
-                                if ( 0 !== strpos( $port_or_socket, '/' ) ) {
-                                        $port = intval( $port_or_socket );
-                                        $maybe_socket = strstr( $port_or_socket, ':' );
-                                        if ( ! empty( $maybe_socket ) ) {
-                                                $socket = substr( $maybe_socket, 1 );
-                                        }
-                                } else {
-                                        $socket = $port_or_socket;
+                                switch(0)
+                                {
+                                        case strpos( $port_or_socket, '/' ): # linux socket
+                                        case strpos( $port_or_socket, '\\'): # windows pipe
+                                                $socket = $port_or_socket;
+                                                break;
+                                        default:
+                                                $port = intval( $port_or_socket );
+                                                $maybe_socket = strstr( $port_or_socket, ':' );
+                                                if ( ! empty( $maybe_socket ) ) {
+                                                        $socket = substr( $maybe_socket, 1 );
+                                                }
                                 }
                         }
 
                         if ( WP_DEBUG ) {
                                 mysqli_real_connect( $this->dbh, $host, $this->dbuser, $this->dbpassword, null, $port, $socket, $client_flags );
@@ -1468 +1472 @@
                                         $this->use_mysqli = false;
                                         $this->db_connect();
                                 }
                         }
                 } else {
+                        if ( ! empty( $port_or_socket ) ) {
+                                $host = substr( $host, 0, strpos( $host, ':' ) );
+                                $port_or_socket = substr( $port_or_socket, 1 );
+                                if( 0===strpos( $port_or_socket, '\\' )) # windows pipe
+                                {
+                                        ini_set('mysql.default_host', $host);
+                                        ini_set('mysql.default_socket', $port_or_socket);
+                                }
+                        }
+                        
                         if ( WP_DEBUG ) {
                                 $this->dbh = mysql_connect( $this->dbhost, $this->dbuser, $this->dbpassword, $new_link, $client_flags );
                         } else {
                                 $this->dbh = @mysql_connect( $this->dbhost, $this->dbuser, $this->dbpassword, $new_link, $client_flags );
                         }

[bogdan.ionescu]

wp-db.php diff from revision 32925

[bogdan.ionescu]

MySQL config file

[bogdan.ionescu]

Wordpress config file

[pento]

This isn't something that we've seen much interest in over the years.

If someone wants to make a new patch, along with unit tests, I'm happy for this ticket to be reopened. Until then, I'm going to close it.