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'] = '';
$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