phpMyAdmin has no UPDATE, SELECT, INSERT, DELETE function

[Any Who]

How do you write a query to add UPDATE, SELECT, INSERT, DELETE

I already tried:

GRANT UPDATE, SELECT, INSERT, DELETE to name_db

but this gives a synthax error message no 1064

Please can anybody help me? ElseI don't get any php script at work!

[brian.mark]

You need to add in who can do these functions.

GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ...
    ON {tbl_name | * | *.* | db_name.*}
    TO user [IDENTIFIED BY [PASSWORD] 'password']
        [, user [IDENTIFIED BY [PASSWORD] 'password']] ...
    [REQUIRE
        NONE |
        [{SSL| X509}]
        [CIPHER 'cipher' [AND]]
        [ISSUER 'issuer' [AND]]
        [SUBJECT 'subject']]
    [WITH with_option [with_option] ...]

http://dev.mysql.com/doc/refman/4.1/en/grant.html

Brian.

[Any Who]

Thanks for helping me, but you're as unclear as the manual. Sorry, but I don't understand those symbols, I always need examples to understand how a script works. Can you write the same code but while using names for tables, account and so on?

I don't know if you understand well the real problem. In a normal php account, in the phpMyadmin you can mark these 4 functions from a list of six. Well in my account there is no list at all. And because of that I should write a query.

[brian.mark]

Originally Posted by Any Who

Thanks for helping me, but you're as unclear as the manual. Sorry, but I don't understand those symbols, I always need examples to understand how a script works. Can you write the same code but while using names for tables, account and so on?

I don't know if you understand well the real problem. In a normal php account, in the phpMyadmin you can mark these 4 functions from a list of six. Well in my account there is no list at all. And because of that I should write a query.

GRANT UPDATE, SELECT, INSERT, DELETE ON name_db TO anywho IDENTIFIED BY PASSWORD 'userpassword';

You have to tell it who can do stuff on that database, not just grant this to a database.

Brian.