mySQL entry delete from php

[XiVoid]

I'm trying to delete an entry from my database, but I always get the following error:

 

DELETE command denied to user 'dbUser' @ 'server' for table 'myTable'

 

 

The credentials that I am using allow me to insert and update this and other tables.

If I run the command in phpMyAdmin:

 

DELETE FROM myTable WHERE recordNo = 12

 

it executes perfectly.

 

But in my php code:

 

$sql = "DELETE FROM myTable WHERE recordNo = '$recordNo'";

 

returns the error.

 

I'm using my database's R/W login details.

 

Are there other credentials I should be using?

What am I doing wrong?

 

Any help would be appreciated.

Please

 

[skali]

Seems like the user that you are making connection to MySQL with is not allowed to execute delete commands..

 

You will have to grant these permission to the user that you are using.

[XiVoid]

ok.

 

Where would I do that?

In phpMyAdmin?

 

Sorry, I'm very new at php and mysql.

[skali]

Yes, either phpmyadmin or shell if you have access to it...

[XiVoid]

thank you, Skali.