Access denied for user 'root'@'localhost' (using password: YES)

[Guest kirara]

hey guys,

 

I'm new here and I want to ask question about this problem (the one in the title). I don't want to be a Help Vampire but I have tried many options in fixing this problem.

 

I think this is an issue about Incorrect: Username/Password.

 

I am trying to connect to my local server with the username="root", pasword="",host="localhost",dbName="dbname";

 

I have 2 connections, One is I'm using class to connect and the other is I'm using a procedural programming. I can connect to my 2nd connection using the procedural but I can't connect to my 1st connection using classes. I'm still new to php and want to learn about it. I've tried google-ing and found any suggestions but still it doesn't work.

 

1st Connection: This one shows Error (Access is Denied)

 

<? //filename: sampleOOP.php

include('config.php');

include('classLib_inc.php');

 

echo DB_HOST . "

";

echo DB_NAME . "

";

echo DB_USER . "

";

echo DB_PASS . "

";

 

$db = new database(DB_HOST,DB_NAME,DB_USER,DB_PASS);

 

$db->_connect();

$db->_query("SELECT * FROM tblmonths");

 

$db->_numberOfRows();

?>

 

 

2nd Connection: Connection is Good

 

<?php #filename: didpconnect.php

 

$dbName = "didp";

$dbHost = "localhost";

$dbUser = "root";

$dbPass = "";

 

$conn = mysql_connect($dbHost,$dbUser,$dbPass);

mysql_select_db($dbName,$conn);

?>

 

<?php //samplePage.php

include('didpconnect.php');

global $conn;

 

$sqlSp = "SELECT * FROM tblprojects";

$qrySp = mysql_query($sqlSp,$conn) or die("ERROR:" .mysql_error());

?>

Project Type

Project

--Select Project--

<?php

while($proj = mysql_fetch_array($qrySp)){

$id = $proj['id'];

$project = $proj['project'];

Can you help me Fix this problem?

I'm still researching about this prob. I'm trying my very best to fix this.

 

Thanks,

kirara

 

More Power Killersites.com

[falkencreative]

From the first example... what is the code you are using to set DB_HOST, DB_NAME, etc? and what is your actual database class look like?