Menu
Community /Pin to ProfileBookmark
@NogDogMay 28.2012 — #My guess is that at that point in the code, the variables you are using do not have any values, so it is trying to connect using the user name that is running your PHP script with no password. Thus one of the problems of depending on global variables. ?
But that's only a guess without doing some debugging to find out what the values are of those globals at that point in the code, then if not set (or wrong), tracing back through the code to see where they are defined or overwritten/unset.@NogDogMay 28.2012 — #How are you confirming the values? Something like this?
It certainly sounds like they are empty, since the default values come from the PHP config, which would explain the user name if $GLOBALS['dbUser'] were empty:
resource [B]mysql_connect [/B]([ string $server = ini_get("mysql.default_host") [, string $username =[COLOR="Red"]ini_get("mysql.default_user")[/COLOR] [, string $password = [COLOR="Red"]ini_get("mysql.default_password")[/COLOR] [, bool $new_link = false [, int $client_flags = 0 ]]]]] )@NogDogMay 28.2012 — #Uh-oh, sounds like somebody turned on [url=http://www.php.net/manual/en/ini.core.php#ini.sql.safe-mode]sql.safe_mode[/url] on the web host. ?
MySQL: Logging in as wrong user?
Hello,
I know it is not the best practice but I am working on a site for a friend and I am trying to figure out a weird issue with PHP/MySQL. I try logging in as the user root (I know this is not recommended), and the root password, which are both stored in globals. I’ve had the following code which was working for several years, until one day it stopped work mysteriously.
I am trying the following code here:
[code=php]
<?php
$con = mysql_connect($GLOBALS[“dbHost”], $GLOBALS[“dbUser”], $GLOBALS[“dbPass”]);
if (!$con)
{
die(‘Could not connect: ‘ . mysql_error());
}
mysql_select_db($GLOBALS[“dbName”]);
mysql_query(“SET NAMES ‘utf8’ COLLATE ‘utf8_general_ci'”);
$sql=”SELECT * FROM `householdinfo_” . $year . “` WHERE geography =’99’ && subgeography ='” . $subgeoStr. “‘ && familytype LIKE'” . $famTypeStr . “%'”;
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
echo $row[‘geography’] . “;” . $row[‘subgeography’] . “;” . $row[‘familytype’] . “;” . $row[‘familycount’] . “;” . $row[‘medianincome’];
}
mysql_close($con);
?>
I have double checked the contents of the globals, and the username/password/database defined in the globals are correct.
Howevere I get the following error:
[code=php]
Could not connect: Access denied for user ‘www-data’@’localhost’ (using password: NO)
Is there any reason why when I try logging in as “root” it returns an error saying that I am trying to login as www-data without a password?
I have googled this for quite some time and the general result is either that I have run out of available connections from another PHP script not closing the mysql connecetion properly. However I have been unable to verify if that’s the case here.
Sign in
to post a comment10 Comments(s) ↴
0
@NogDogMay 28.2012 — #My guess is that at that point in the code, the variables you are using do not have any values, so it is trying to connect using the user name that is running your PHP script with no password. Thus one of the problems of depending on global variables. ?But that's only a guess without doing some debugging to find out what the values are of those globals at that point in the code, then if not set (or wrong), tracing back through the code to see where they are defined or overwritten/unset.
0
@NogDogMay 28.2012 — #How are you confirming the values? Something like this?[code=php]
<?php
$con = mysql_connect($GLOBALS["dbHost"], $GLOBALS["dbUser"], $GLOBALS["dbPass"]);
if (!$con)
{
echo "host: '".$GLOBALS['dbHost']."'<br />n";
echo "user: '".$GLOBALS['dbUser']."'<br />n";
echo "pass: '".$GLOBALS['dbPass']."'<br />n";
die('Could not connect: ' . mysql_error());
}
[/code]It certainly sounds like they are empty, since the default values come from the PHP config, which would explain the user name if $GLOBALS['dbUser'] were empty:
resource [B]mysql_connect [/B]([ string $server = ini_get("mysql.default_host") [, string $username =
0
@NogDogMay 28.2012 — #Uh-oh, sounds like somebody turned on