Results 1 to 3 of 3

Thread: access denied

  1. #1
    Join Date
    Dec 2007
    Posts
    2

    Unanswered: access denied

    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"

  2. #2
    Join Date
    Dec 2007
    Posts
    3
    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.

  3. #3
    Join Date
    Dec 2007
    Posts
    2
    oops, seems i had mistaken table and database names xD
    Last edited by fuzzalicious; 12-11-07 at 14:36.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •