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@xxxxxx> 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@xxxxxxxxx>
Phone: (815) 355-7285
Instant Messenger: AIM & Yahoo! IM - colonelforbin74 | ICQ - #39374451
Adam W. Dace <colonelforbin74@xxxxxxxxx>
Phone: (815) 355-7285
Instant Messenger: AIM & Yahoo! IM - colonelforbin74 | ICQ - #39374451
Google Profile: https://plus.google.com/u/0/109309036874332290399/about
