Re: PHP 7.4.0 + MySQL

Thank you for the link, and yes that's actually an issue I've dealt with for PHP 7.3.X. This time around, with PHP 7.4.X I can't even get that far...it simply refuses to connect, seemingly no matter what I do. Just for documentation, the exact error is: mysqli_real_connect(): (HY000/2006): MySQL server has gone away For now I'll just give it a break, hopefully post-release there will be more information available about this kind of problem. :) Thanks, Adam P.S. Just FYI I tried all sorts goofy things just for fun, connecting via TCP/IP, mysql_native_authentication, etc. No luck. :( On Sat, Sep 7, 2019 at 2:45 AM Christoph M. Becker <cmbecker69@gmx.de> wrote: > 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 > -- ____________________________________________________________ Adam W. Dace <colonelforbin74@gmail.com> Phone: (815) 355-7285 Instant Messenger: AIM & Yahoo! IM - colonelforbin74 | ICQ - #39374451 Google Profile: https://plus.google.com/u/0/109309036874332290399/about