SHELL Command to add user to database

Discussion in 'MySQL' started by sawz, Sep 14, 2008.

0
  1. #1
    i have quite a few databases and i just moved servers. is there a shell command that i can use to apply a user to all databases at the same time?
     
    sawz, Sep 14, 2008 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Use GRANT ALL.
    GRANT ALL ON *.* TO 'someuser'@'somehost';
    Code (markup):
     
    mwasif, Sep 14, 2008 IP