PHP :: Bug #81055 :: $mysqli->real_connect connecting to socket exception

Bug #81055	$mysqli->real_connect connecting to socket exception
Submitted:	2021-05-19 18:09 UTC	Modified:	2023-01-10 17:15 UTC
From:	ivsucic at fesb dot hr	Assigned:
Status:	Open	Package:	MySQLi related
PHP Version:	7.4Git-2021-05-19 (Git)	OS:	wsl2 debian
Private report:	No	CVE-ID:	None

View Developer Edit

Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !

Your email address: MUST BE VALID
Solve the problem: 33 + 48 = ?
Subscribe to this entry?

[2021-05-19 18:09 UTC] 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports

[2021-05-21 14:00 UTC] cmb@php.net

-Status: Open +Status: Feedback -Assigned To: +Assigned To: cmb

[2021-05-21 14:00 UTC] 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-21 15:45 UTC] ivsucic at fesb dot hr

-Status: Feedback +Status: Assigned

[2021-05-21 15:45 UTC] 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 16:00 UTC] cmb@php.net

-Status: Assigned +Status: Feedback

[2021-05-21 16:00 UTC] 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 20:50 UTC] ivsucic at fesb dot hr

-Status: Feedback +Status: Assigned

[2021-05-21 20:50 UTC] ivsucic at fesb dot hr

I am using mysql 8. I can connect via tcp/ip

[2021-05-22 21:33 UTC] cmb@php.net

-Status: Assigned +Status: Open -Assigned To: cmb +Assigned To:

[2021-05-22 21:33 UTC] cmb@php.net

Thanks for providing further info!

I'll leave this ticket for someone else more used to connecting to
a MySQL server via Unix sockets.

[2022-12-14 08:45 UTC] Redick121ouise at gmail dot com

Object-oriented style

public mysqli::real_connect(
    string $host = ?,
    string $username = ?,
    string $passwd = ?,
    string $dbname = ?,
    int $port = ?,
    string $socket = ?,
    int $flags = ?
): bool
Procedural style

mysqli_real_connect(
    mysqli $link,
    string $host = ?,
    string $username = ?,
    string $passwd = ?,
    string $dbname = ?,
    int $port = ?,
    string $socket = ?,
    int $flags = ?
): bool

Thanks, (https://www.aetnamedicare.us/)github.com

[2023-01-10 17:15 UTC] dharman@php.net

-Package: MySQL related +Package: MySQLi related

	php.net \| support \| documentation \| report a bug \| advanced search \| search howto \| statistics \| random bug \| login
go to bug id or search bugs for


Copyright © 2001-2025 The PHP Group All rights reserved.	Last updated: Sun Oct 26 08:00:02 2025 UTC