Re: PHP 7.4.0 + MySQL

On 07.09.2019 at 02:58, Adam W. Dace wrote: > 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. :) Perhaps you're hitting <https://github.com/phpmyadmin/phpmyadmin/issues/14220>. -- Christoph M. Becker