mySQL + PHP >> SELECT command denied to user ''@'localhost' for table 'menu' :: 1142

anselme · #1 (**permalink**) 07-14-08, 02:52

I am using php wamp 2.0 on windows xp pro

my code

Code:

$server = "localhost";
$username = "root";
$password = "";
$database = "rufus";

$con = mysql_connect($server,$username,$password);

if (!$con)
  {
  die($errDbConn . mysql_error() . " :: " . mysql_errno());
  }

$db_selected = mysql_select_db($database, $con);

$result = mysql_query("SELECT * FROM rufus.menu;");

and I'm receiving the following error: SELECT command denied to user ''@'localhost' for table 'menu' :: 1142

mySQL is runing , database and tables are ok

I have tried
mysql > GRANT SELECT, INSERT, UPDATE, DELETE on anselme.* TO 'root'@'%' IDENTIFIED BY '';

mysql > SHOW GRANTS FOR root;

I get
GRANT USAGE ON *.* TO 'root'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE on anselme.* TO 'root'@'%'

but allways the same error 1142

thanks for helping

Yuri Novaes · #2 (**permalink**) 01-19-09, 15:16

anselme,

in the linhe: $result = mysql_query("SELECT * FROM rufus.menu;");

DELETE references for the database rufus.

Line final:

$result = mysql_query("SELECT * FROM menu;");

Regards,

Yuri Novaes

bougalove · #3 (**permalink**) 01-20-09, 09:39

Hi there

i am having a problem on connecting to Database Server , i have configured MySql and it's running but when i try to configure a database for Testlink application i get this error " TestLink setup will now attempt to setup the database:Creating connection to Database Server: Failed! "

Thanks for your help.

anselme · #4 (**permalink**) 01-21-09, 04:31

it works

thank you

Internet Services

Web Development

Digital Marketing

Consumer Tech