Local Flywheel used host IP + port for the database server. Local Lightning uses a socket.
I was able to get the socket running for local Codeception tests (.env files), but PhpStorm’s Database tool window cannot use a socket because Storm is written in Java and Java can’t use sockets, per their Storm’s support, which wrote this back to me:
MySQL JDBC driver only supports TCP/IP and - on Windows - named pipes to connect to the database. Please see https://lists.mysql.com/java/8749.
So please enable networking in your MySQL server and use ‘localhost’ with port for connection.
Additional references:
- Connection to a database | PhpStorm Documentation
- Using MySQL Sockets in the WordPress wp-config.php · Sivel.net – which says to put the socket path in your wp-config.php but that’s not actually needed in Local Lightning: Image 2020-03-13 at 3.16.50 PM
So, please advise – maybe ‘localhost’ is sufficient, like wp-config.php seems good with but I need a different port#???