i made a database in phpmyadmin, and used all information given by the service provided, but i can't grant access do my user.'

i can alter and change my database from phpmyadmin, but when i try a command like "grant select on database.table_name to 'user'@'%';" to be able to view the table from a website, i get "#1142 - SELECT,GRANT command denied to user 'xxx'@'xxx.xxx.net' for table 'xxx'"

if i try a "identified by" i get "#1132 - You must have privileges to update tables in the mysql database to be able to change passwords for others"

hi,

Sounds like you dont have "root" access to your database.

You might want to ask your SP(Service Provider) for help on this issue.

oops, seems i had mistaken table and database names xD