Bug #78870 [Com]: Connection errors appear in error.log

Edit report at https://bugs.php.net/bug.php?id=78870&edit=1 ID: 78870 Comment by: hhsnakeg at gmail dot com Reported by: hhsnakeg at gmail dot com Summary: Connection errors appear in error.log Status: Feedback Type: Bug Package: MySQLi related PHP Version: 7.2.25 Assigned To: cmb Block user comment: N Private report: N New Comment: 1. use 7.2.24 2. use mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $ ($connectionID->get_client_info();) Package: php7.2-mysql Version: 7.2.24-1+ubuntu18.04.1+deb.sury.org+1 Provides: php-mysqli, php-mysqlnd, php-pdo-mysql, php7.2-mysqli, php7.2-mysqlnd, php7.2-pdo-mysql Previous Comments: ------------------------------------------------------------------------ [2019-11-26 13:47:39] cmb@php.net Just to clarify: - are you using PHP 7.2.25 or 7.2.24? - which driver do you use – mysqlnd or libmysqlclient? ------------------------------------------------------------------------ [2019-11-26 13:13:49] hhsnakeg at gmail dot com Description: ------------ When I use persist connection on PHP use call mysqli_real_connect with parameter host 'p:localhost' causes error connection when I call the connection second time. After that, a new database connection is created with a new id. When we connect to the database for the first time we see a message in the general log: 454 Connect dbuser@localhost on dbscheme using Socket When we reuse connection (connect second time) we see a message in the general log: 454 Connect Access denied for user 'dbuser'@'localhost' (using password: NO) 455 Connect dbuser@localhost on dbscheme using Socket and in the error log we see the same message: 454 [Note] Access denied for user 'dbuser'@'localhost' (using password: NO) I think this error appeared after changes in version 7.2.24 (Fixed bug #76809 (SSL settings aren't respected when persistent connections are used). Test script: --------------- <?php function connect() { $connectionID = mysqli_init(); $ok = mysqli_real_connect($connectionID, 'p:localhost', 'dbuser', 'dbpass', 'dbscheme', 3306, "", 0); mysqli_select_db($connectionID, 'dbsheme'); } connect(); connect(); ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=78870&edit=1