I am using Local by Flywheel which connects to MySQL with sockets. My socket is:
/Users/efc/Library/Application Support/Local/run/Qv8NIbiue/mysqld.sock
The MySQL server is localhost
, database is local
, and both username and password are root
(and this really is a root account, I can even create new databases with SequelPro).
When I try to install CiviCRM 5.21.1 on WordPress 5.3.2 I get the error "Can't find the a MySQL server on 'localhost'.: The server requested authentication method unknown to the client" on the "Does the server exist?" line of the CiviCRM Installer screen. Oddly enough, every other item in "CiviCRM Database Details" is "OK" (green). In other words, even though it thinks it can't find the server, it seems to be able to do every other thing OK.
I cannot figure out how to tell CiviCRM what it needs to know to be happy about the MySQL server. How can I make this WordPress install work with sockets?
If I try to put "localhost:/Users/efc/Library/Application Support/Local/run/Qv8NIbiue/mysqld.sock" in the MySQL server field, then "Does server exist" is "OK" but almost everything else goes red.
Note, there are answers to similar questions for folks who have come far enough along in the install process to have a civicrm.settings.php
file. But at this stage of the WordPress version's bootstrap it has not yet successfully installed, there is no settings file. This question is about how to respond to this error so that the WordPress version of CiviCRM can be installed in the first place.