1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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