| 
        php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login | 
 PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits             
             [2020-11-09 15:39 UTC] fjanisze@php.net
 
-Status:      Open
+Status:      Analyzed
-Assigned To:
+Assigned To: fjanisze
  | 
    |||||||||||||||||||||||||||
            
                 
                Copyright © 2001-2025 The PHP GroupAll rights reserved.  | 
        Last updated: Tue Nov 04 07:00:01 2025 UTC | 
Description: ------------ The authentication methods SCRAM-SHA-1 and SCRAM-SHA-256 have to be supported, this issue is about adding support for them in mysqlnd. Test script: --------------- <?php $link = mysqli_connect("127.0.0.1", "user", "pass"); // Check connection if($link === false){ die("ERROR: Could not connect. " . mysqli_connect_error()); } // Print host information echo "Connect Successfully. Host info: " . mysqli_get_host_info($link) . PHP_EOL; if ($result = $link->query("SHOW DATABASES")) { echo "Returned rows are: " . $result->num_rows . PHP_EOL; // Free the result set $result->free_result(); } ?> Expected result: ---------------- Given the script and assuming that 127.0.0.1 runs a mysql server configured with LDAP SASL and auth method SCRAM-SHA-1 or SCRAM-SHA-256 for the user "user", the script succeeds and the query works. Actual result: -------------- The connection will fail since mysqlnd is not able to authenticate, at the moment LDAP SASL is not supported in the client but the server does support those methods.