ID: 43812 Updated by: [EMAIL PROTECTED] Reported By: graced at wingsnw dot com -Status: Open +Status: Assigned Bug Type: MySQLi related Operating System: Debian lenny/sid PHP Version: 5.2.5 -Assigned To: +Assigned To: andrei
Previous Comments: ------------------------------------------------------------------------ [2008-01-11 03:32:02] graced at wingsnw dot com Description: ------------ my.cnf files allow the username/password/hostname and other connection information to be stored for later use. The Mysqli extension accepts a username from the file (overriding the default of the current login username) but not a password, thus it attempts to connect with no password even when a password is specified. The mysql command line client, when pointed at the file using --defaults-extra-file=path/to/file.cnf, successfully connects. Reproduce code: --------------- my.cnf contents: [client] host = localhost user = "username" password = "topsecret" PHP script: <?php error_reporting(E_ALL); $DB = mysqli_init(); $DB->options(MYSQLI_READ_DEFAULT_FILE, "my.cnf"); $DB->options(MYSQLI_READ_DEFAULT_GROUP, "client"); $DB->real_connect(); Expected result: ---------------- A successful database connection. Actual result: -------------- Warning: mysqli::real_connect(): (28000/1045): Access denied for user 'wadmin'@'localhost' (using password: NO) in /home/.../- on line 6 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=43812&edit=1
