Results 1 to 2 of 2

Thread: sql error

  1. #1
    Join Date
    Aug 2011
    Posts
    1

    Post sql error

    im glad to write my problem here to the experts of sql , and very nice that there is this forum to help lol.
    my problem is >
    i get this error > Database error: Invalid SQL: SELECT * FROM portobel_advert.categories
    MySQL Error: 1142 (SELECT command denied to user 'hagdacom_db'@'localhost' for table 'categories')
    Session halted.

    so i wonder what problem is this and what file is asking and how to fix this pls.
    im ready to give more explication if you need .
    thanks

  2. #2
    Join Date
    Apr 2012
    Posts
    7
    The most probable reason of error is that user does not have the permission to do select queries. Ask database administrator (or anyone having root access) grant the appropriate permission to the user:

    GRANT SELECT ON portobel_advert.categories TO 'hagdacom_db'@'localhost'

Posting Permissions

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