Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012
    Posts
    1

    Unanswered: New to MYSQl can someone tell me what this means?

    Hi I'm very new to MYSQL, I am trying to get my head around all of it and it is slowly working.

    Could osmeone please tell me in basic detail what this means? I have google each term seperatly, however some of the explanations seem very longed out

    Thanks for your co-operation, any help at all would be appreciated.

    Code:
    GRANT ALL PRIVILEGES 
    ON cwkdb.* 
    TO cwk@localhost 
    IDENTIFIED BY 'cyan' 
    WITH GRANT OPTION;

  2. #2
    Join Date
    May 2012
    Posts
    1
    Its Simple!
    GRANT ALL PRIVILEGES----- Means you are granting Insert, delete, alter and all DML permissions.
    ON cwkdb.* ----If you want to grant permission to do some operations then you need to tell on whom you are going to perform the operations, I mean Table or functionetc. here it would be cwkdb.
    TO cwk@localhost---- You need to identify the person or user to whom you are giving these permissions---- user specification

Posting Permissions

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