Bug #81055 [Asn->Opn]: $mysqli->real_connect connecting to socket exception

Edit report at https://bugs.php.net/bug.php?id=81055&edit=1 ID: 81055 Updated by: cmb@php.net Reported by: ivsucic at fesb dot hr Summary: $mysqli->real_connect connecting to socket exception -Status: Assigned +Status: Open Type: Bug Package: MySQL related Operating System: wsl2 debian PHP Version: 7.4Git-2021-05-19 (Git) -Assigned To: cmb +Assigned To: Block user comment: N Private report: N New Comment: Thanks for providing further info! I'll leave this ticket for someone else more used to connecting to a MySQL server via Unix sockets. Previous Comments: ------------------------------------------------------------------------ [2021-05-21 20:50:45] ivsucic at fesb dot hr I am using mysql 8. I can connect via tcp/ip ------------------------------------------------------------------------ [2021-05-21 16:00:01] cmb@php.net Thanks for the info! With "server version" I meant the version of MySQL (if it's even MySQL and not MariaDB or such). Anyhow, if you can connect with phpmyadmin, the MySQL server is probably irrelevant. Maybe there are issues with unix sockets under WSL2? Can you connect via TCP/IP with mysqli? ------------------------------------------------------------------------ [2021-05-21 15:45:48] ivsucic at fesb dot hr Are both client and server running on WSL2? Yes, both are running on wsl2. What is your Client API library version (see phpinfo)? mysqlnd 7.4.15 Can you connect via mysqli? Using phpmyadmin with password authentication works. What's your server version? Apache 2.0 Handler ------------------------------------------------------------------------ [2021-05-21 14:00:04] cmb@php.net Are both client and server running on WSL2? What is your Client API library version (see phpinfo)? Can you connect via mysqli? What's your server version? ------------------------------------------------------------------------ [2021-05-19 18:09:52] ivsucic at fesb dot hr Description: ------------ When connecting to a mysql db with mysqli->real_connect using unix socket it gives an exception unexpected server response while doing caching_sha2 auth. The user of apache2 is changed as needed. Test script: --------------- $mysqli->real_connect(null, 'ivan', 'ivan', 'phpmyadmin', 0, '/var/run/mysqld/mysqld.sock'); Expected result: ---------------- Establishing a connection to db Actual result: -------------- Exception unexpected server response while doing caching_sha2 auth ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=81055&edit=1