I just did a brew upgrade
to PHP 7.2.8 and MySQL 8.0.12. After this, trying to connect to MySQL from a PHP script (from Bash) times out after 10 seconds (the default MySQL timeout value).
new PDO("mysql:host=localhost;dbname=foo;charset=utf8", "user", "pass");
[2006] MySQL server has gone away
Everything in my environment seems to be normal. I haven't changed anything else in my setup. Connecting to MySQL from Bash works fine. How do I regain MySQL access from PHP?
$ php -i | grep php.ini
Configuration File (php.ini) Path => /usr/local/etc/php/7.2
Loaded Configuration File => /usr/local/etc/php/7.2/php.ini
$ tail /usr/local/etc/php/7.2/php.ini
mysql.default_socket = /tmp/mysql.sock
pdo_mysql.default_socket = /tmp/mysql.sock
$ ls /tmp/mysql*
srwxrwxrwx 0 /tmp/mysql.sock
-rw------- 5 /tmp/mysql.sock.lock
srwxrwxrwx 0 /tmp/mysqlx.sock
-rw------- 6 /tmp/mysqlx.sock.lock
$ mysql
Welcome to the MySQL monitor.
mysql> show variables like '%socket%';
+-----------------------------------------+------------------+
| mysqlx_socket | /tmp/mysqlx.sock |
| socket | /tmp/mysql.sock |
+-----------------------------------------+------------------+