Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    150

    Unanswered: SQL Syntax problem

    I have a query that looks like this:

    GRANT select, insert, update, delete
    ON content.*
    TO audio-occasion_qc_ca_-_content@localhost identified by 'password';

    And it keeps crashing on the first '-' character it hits.... it there a way to use another character or enclose the words somehow to fix this?

    I cannot unfortunately rename my db prefix .

    Thanks!
    Cheers!

    Mr.Crud

    There are 10 kinds of people, ones that understand digital, others that dont

  2. #2
    Join Date
    Sep 2004
    Posts
    46
    this: "audio-occasion_qc_ca_-_content" must be user not dbname

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Check the MySQL GRANT documentation. I think what you want is:
    Code:
    GRANT select, insert, update, delete
       ON content.*
       TO 'audio-occasion_qc_ca_-_content'@'localhost' identified by 'password';
    -PatP
    Last edited by Pat Phelan; 10-29-04 at 18:03.

Posting Permissions

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