#43812 [Opn->Asn]: 'password' parameter in my.cnf not honored even with mysqli_options()

From:	tony2001@php.net	Date:	Sat, 12 Jan 2008 15:28:16 +0000
Subject:	#43812 [Opn->Asn]: 'password' parameter in my.cnf not honored even with mysqli_options()
References:	1	Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-121220@lists.php.net to get a copy of this message

 ID:               43812
 Updated by:       tony2001@php.net
 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


   

Thread (25 messages)

• graced at wingsnw dot comFri, 11 Jan 2008 03:32:02 +0000
  • tony2001@php.netSat, 12 Jan 2008 15:28:16 +0000#43812 [Opn->Asn]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • graced at wingsnw dot comTue, 15 Jan 2008 05:03:13 +0000#43812 [Asn]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • uw@php.netMon, 14 Jul 2008 20:28:39 +0000#43812 [Asn->Fbk]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • jarrod dot makin at heartinternet dot co dot ukThu, 12 Feb 2009 00:57:37 +0000#43812 [Com]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • axz55 at case dot eduMon, 27 Jul 2009 06:36:23 +0000#43812 [Com]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • ben at redsnapper dot netThu, 26 Feb 2015 16:47:49 +0000Bug #43812 [Com]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • fms at hy dot com dot brWed, 06 Jan 2016 19:11:35 +0000Bug #43812 [Com]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • requinix@php.netWed, 06 Jan 2016 20:01:25 +0000Bug #43812 [NoF]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • ben at redsnapper dot netWed, 06 Jan 2016 20:53:58 +0000Bug #43812 [Com]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • requinix@php.netWed, 06 Jan 2016 20:57:23 +0000Bug #43812 [NoF]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • ben at redsnapper dot netWed, 06 Jan 2016 23:06:09 +0000Bug #43812 [Com]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • requinix@php.netThu, 07 Jan 2016 04:54:14 +0000Bug #43812 [NoF]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • requinix@php.netThu, 07 Jan 2016 04:54:35 +0000Bug #43812 [NoF->Fbk]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • ben at redsnapper dot netThu, 07 Jan 2016 20:30:16 +0000Bug #43812 [Com]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • php-bugs at lists dot php dot netSun, 17 Jan 2016 04:22:33 +0000Bug #43812 [Fbk->NoF]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • requinix@php.netSun, 17 Jan 2016 04:39:44 +0000Bug #43812 [NoF->ReO]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • hsc@php.netMon, 12 Dec 2016 13:14:55 +0000Bug #43812 [Com]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • juan at verdnatura dot esMon, 06 Mar 2017 16:32:18 +0000Bug #43812 [Com]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • fjanisze@php.netTue, 18 Apr 2017 09:36:25 +0000Bug #43812 [ReO->Fbk]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • ben at redsnapper dot netTue, 18 Apr 2017 11:11:56 +0000Bug #43812 [Com]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • ben at redsnapper dot netTue, 18 Apr 2017 12:00:32 +0000Bug #43812 [Com]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • php-bugs at lists dot php dot netSun, 30 Apr 2017 04:22:33 +0000Bug #43812 [Fbk->NoF]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • requinix@php.netSun, 30 Apr 2017 07:20:54 +0000Bug #43812 [NoF->Opn]: 'password' parameter in my.cnf not honored even with mysqli_options()
  • nikic@php.netThu, 29 Oct 2020 10:20:27 +0000Bug #43812 [Opn]: MYSQLI_READ_DEFAULT_FILE option ignored when using mysqlnd