mysql - password error - Programming & Web Design

December 28, 200619 yr

I'm receiving this error:

PHP Fatal error: Access denied for user 'root'@'localhost' (using password: NO) in /home/.sites/85/site23/web/Connections/MineWorks.php on line 9

Here's the code:

<?php require_once('Connections/MineWorks.php'); ?>

<?php

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {

case "text":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "long":

case "int":

$theValue = ($theValue != "") ? intval($theValue) : "NULL";

break;

case "double":

$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";

break;

case "date":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "defined":

$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

break;

}

return $theValue;

}

$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {

$insertSQL = sprintf("INSERT INTO test (`first`) VALUES (%s)",

GetSQLValueString($_POST['first'], "text"));

mysql_select_db($database_MineWorks, $MineWorks);

$Result1 = mysql_query($insertSQL, $MineWorks) or die(mysql_error());

$insertGoTo = "success.php";

if (isset($_SERVER['QUERY_STRING'])) {

$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";

$insertGoTo .= $_SERVER['QUERY_STRING'];

}

header(sprintf("Location: %s", $insertGoTo));

}

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>Untitled Document</title>

</head>

<body>

<tr>

<td>first</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

</form>

</body>

</html>

Here's my Connection file:

<?php

# FileName="Connection_php_mysql.htm"

# Type="MYSQL"

# HTTP="true"

$hostname_MineWorks = "localhost";

$database_MineWorks = "mineworks";

$username_MineWorks = "root";

$password_MineWorks = "";

$MineWorks = mysql_pconnect($hostname_MineWorks, $username_MineWorks, $password_MineWorks) or trigger_error(mysql_error(),E_USER_ERROR);

?>

When I set my connection in Dreamweaver MX I'm using localhost for mysql server, root for user and pw is left blank.

When I use the page locally and check the table, the information is stored. When I try to use the page remotely, I don't see anything but a blank white page. My hosting company told me what the error message is they received.

Any suggestions?

Thanks,

Reid

Quote

Report

December 28, 200619 yr

Maybe your hosting company is using a different mySQL password?

Quote

Report

December 28, 200619 yr

Author

Maybe your hosting company is using a different mySQL password?

As I'm very new to php mysql etc., please be patient.

I'm using Dreamweaver and when I create the page, I use the settings for my testing server (on my machine). Should I then change the settings to the user id and pw as per the hosting information?

Thanks.

Quote