DB Login Error

[vmacs]

When i used to connect mysql locally, i use localhost,"root", "root" it works well. But when i upload in the site it throws the following error . Can any one help me please. It is urgent one.
Warning: Access denied for user: 'root@localhost' (Using password: NO)
could not connect

Even if i create the user as bluestone and password as root. I am able to work after login as bluestone user. But after uploading i got the following error

Warning: Access denied for user: 'bluestone@localhost' (Using password: NO)
could not connect
help me

regards
Chandra Sekar

[nnichols]

It sounds like you need to check your account details and find out what the db server username & password are.

It certainly shouldn't have a password of 'root'.

When asking questions you should also post the code that is failing if possible.

$conn = mysql_[p]connect('localhost', 'user', 'pass');

I put the [p] to indicate either persistent or non-persistent.

[vmacs]

<?
include("ClsOP_Connection.inc");

$ObjConnection = new OP_Connection("localhost","bluestone","root","OrderProcessing");

$ObjConnection->Open();
?>

when i connect the db it is saying

Warning: Access denied for user: 'bluestone@localhost' (Using password: NO) in /Library/WebServer/Documents/Bluestone/ClsOP_Connection.inc on line 20

Warning: MySQL Connection Failed: Access denied for user: 'bluestone@localhost' (Using password: NO) in /Library/WebServer/Documents/Bluestone/ClsOP_Connection.inc on line 20
Could not connect

pls help me

[nnichols]

I need to see the code that is failing in the include file. As I said before you should check that the connection details are correct.

[vmacs]

<?
include("ClsOP_Connection.inc");

$ObjConnection = new OP_Connection("localhost","root","root","Orderprocessing");

$ObjConnection->Open();
?>

//ClsOP_Connction.inc
<?
class OP_Connection
{
var $StrHost;
var $StrUserid;
var $StrPassword;
var $StrDatabase;
var $StrLink;

   Function OP_Connection($THost, $TUserid, $TPwd, $TDatabase)
   {
       $this->StrHost = $THost;
       $this->StrUserid = $TUserid;
       $this->StrPassword = $TPwd;
       $this->StrDatabase = $TDatabase;
   }

   Function Open()
   {
       $this->Strlink = mysql_connect($this->Strhost, $this->StrUserid, $this->Password)
               or die ("Could not connect");
       mysql_select_db($this->StrDatabase)
               or die ("Invalid Data base");
   }

   Function Close()
   {
        mysql_close();
   }

}

?>

[pinoy]

I have fix your code and test it, its working on mine

<?
include("ClsOP_Connection.inc");

$ObjConnection = new OP_Connection("localhost","root","root","Orderprocessing");

$ObjConnection->Open();
?>

//ClsOP_Connction.inc
<?
class OP_Connection
{
var $StrHost;
var $StrUserid;
var $StrPassword;
var $StrDatabase;
var $StrLink;

Function OP_Connection($THost, $TUserid, $TPwd, $TDatabase)
{
$this->StrHost = $THost;
$this->StrUserid = $TUserid;
$this->StrPassword = $TPwd;
$this->StrDatabase = $TDatabase;
}

Function Open()
{
$this->Strlink = mysql_connect($this->StrHost, $this->StrUserid, $this->StrPassword)
or die ("Could not connect");
mysql_select_db($this->StrDatabase)
or die ("Invalid Data base");
}

Function Close()
{
mysql_close();
}

}

?>

StrPassword StrHost