Bug #81055 [Fbk->Asn]: $mysqli->real_connect connecting to socket exception
Edit report at https://bugs.php.net/bug.php?id=81055&edit=1
ID: 81055
User updated by: ivsucic at fesb dot hr
Reported by: ivsucic at fesb dot hr
Summary: $mysqli->real_connect connecting to socket exception
-Status: Feedback
+Status: Assigned
Type: Bug
Package: MySQL related
Operating System: wsl2 debian
PHP Version: 7.4Git-2021-05-19 (Git)
Assigned To: cmb
Block user comment: N
Private report: N
New Comment:
I am using mysql 8. I can connect via tcp/ip
Previous Comments:
------------------------------------------------------------------------
[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
Thread (7 messages)