php - mysql_connect() : Headers and client library minor version mismatch. header :50531 库:50613

Question

我真的很难在 debian wheezy 上修复这些错误。

mysql_connect(): Headers and client library minor version mismatch. Headers:50531 Library:50613 core.php on line 317

今天升级到 php 5.4、ioncube loaders 4.4.3、xcache 3.0.3 和 percona 5.6 后，问题出现了一段时间。

到目前为止，在我尝试解决问题的过程中，我已经尝试过...

1. 卸载 php(包括清除安装文件)
2. 降级到 php 5.3 然后升级回来
3. 降级回 percona 5.5 并升级回来
4. 正在卸载 ioncube header
5. 正在卸载 xcache

不幸的是，这些都没有帮助......

--

第 317 行开始于:

 $link = $this->

  /**
    * Initialize database connection(s)
    *
    * Connects to the specified master database server, and also to the slave server if it is specified
    *
    * @param        string  Name of the database server - should be either 'localhost' or an IP address
    * @param        integer Port of the database server (usually 3306)
    * @param        string  Username to connect to the database server
    * @param        string  Password associated with the username for the database server
    * @param        boolean Whether or not to use persistent connections to the database server
    * @param        string  Not applicable; config file for MySQLi only
    * @param        string  Force connection character set (to prevent collation errors)
    *
    * @return       boolean
    */
    function db_connect($servername, $port, $username, $password, $usepconnect, $configfile = '', $charset = '')
    {
            if (function_exists('catch_db_error'))
            {
                    set_error_handler('catch_db_error');
            }

            // catch_db_error will handle exiting, no infinite loop here
            do
            {
                    $link = $this->functions[$usepconnect ? 'pconnect' : 'connect']("$servername:$port", $username, $password);
            }
            while ($link == false AND $this->reporterror);

            restore_error_handler();

            if (!empty($charset))
            {
                    if (function_exists('mysql_set_charset'))
                    {
                            mysql_set_charset($charset);
                    }
                    else
                    {
                            $this->sql = "SET NAMES $charset";
                            $this->execute_query(true, $link);
                    }
            }

            return $link;
    }

Answer 1

当我最近将我的 ubuntu 服务器升级到 13.04 时我遇到了同样的问题无论如何这只是来自 libmysqlclient 的警告我也有 mariadb ，你可以使用 php5-mysqlnd而不是 php5-mysql 这为我修复了它。

sudo apt-get remove php5-mysql

sudo apt-get install php5-mysqlnd