i can connect, but i can't do anything

[shyami]

Now i can get a connection, but i can't do anything with this connection
whenever i attempt to select a database or tables,
it saying permission denied, see my code once Plz


$con=@mysql_pconnect("localhost","root","abcd");
if (!$con)
echo "<br>Unable to connect",mysql_error();
else
echo "<br>connected",mysql_error();

$dbcon=@mysql_select_db("project",$con);
if ($dbcon)
echo "<Br>Database Selected";
else
echo "<br>Database not selected",mysql_error();


I got this as a result


connected
Database not selectedAccess denied for user: 'root@localhost' to database 'project'


the same thing happens in console also, what can i do?

send a reply plz!!!!!!!!


Shyami

[uthus]

Hi,

I use something like this for the db's I'm working on:

<?php
  $db=mysql_pconnect('localhost','user','passwd');
  if (!$db)
  {
    echo 'Error: Could not connect to database. Contact the Administrator.';
    exit;
  }
mysql_select_db('database');
$query = "insert into table values ('".firstvalue."', '".secondvalue."')";
$result = mysql_query($query);
.
.
.

?>

hth,

U

[DeadMeatGF]

Try removing the '@' from the commands and see if there are any warnings that shed any more light on the matter.