PHP 7.4.0 + MySQL
| From: | Adam W. Dace | Date: | Sat, 07 Sep 2019 00:58:49 +0000 |
| Subject: | PHP 7.4.0 + MySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-326898@lists.php.net to get a copy of this message | ||
Hello!
I recently attempted upgrading my server, to prepare for v7.4 release, and
am having some problems connecting to a MySQL database running on the same
server.
Currently, I'm running Apache v2.4.41 and PHP v7.3.8 with no problems.
I'm having problems connecting with both phpMyAdmin and WordPress,
though I'll keep the discussion to phpMyAdmin for simplicity's sake.
I feel like I'm missing some sort of configuration, though I have no idea
what it might be.
Information To Follow:
OS: DragonFly BSD Development
Apache: v2.4.41 (stable)
PHP: 7.4.0beta4
MySQL: v8.0.16 (stable)
phpMyAdmin: v4.9.0.1 (stable)
AutoConf: ./configure --with-apxs2=/usr/local/sbin/apxs --disable-debug
--enable-bcmath --enable-gd --enable-mbstring --enable-mysqlnd
--enable-sockets --with-jpeg --with-mysqli --with-openssl --with-zlib
phpMyAdmin Configuration:
$cfg['Servers'][$i]['verbose'] = 'Contact';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
With a similar autoconf and PHP v7.3.8 I have no problems logging in as a
localhost user, viewing databases, making changes, etc. This is all done
via /tmp/mysql.sock.
However, when I try the same configuration with PHP v7.4.0 I get a slight
delay and then the fatal error "MySQL server has gone away.". I believe
this was from mysqli_connect_real().
I've tried changing around phpMyAdmin's configuration...no luck. I've
tried specifying /tmp/mysql.sock to PHP itself...no luck.
Any help or suggestions would be appreciated. I'm kind of stuck. :)
Regards,
Adam