change db permission ?

Discussion in 'Databases' started by skabt, Dec 4, 2012.

0
  1. #1
    any one can guy me how to change DB permission via putty/ssh ???

    btw i ain't ssh guy ....
     
    skabt, Dec 4, 2012 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    What exactly are you trying to change as far as permissions go? Do you have root ssh access?
     
    jestep, Dec 4, 2012 IP
  3. concerto49

    concerto49 Greenhorn

    Messages:
    83
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    10
    #3
    You can ssh into the db if you have an account with the db. If this account has admin rights you can change whatever permissions you need. Which db are you talking about?
     
    concerto49, Dec 5, 2012 IP
  4. serverexpertz

    serverexpertz Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    please specify your exact requirements and the database details so that I can help you better.
     
    serverexpertz, Dec 6, 2012 IP
  5. pstpl1

    pstpl1 Peon

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #5
    GRANT SELECT ON database.* TO user@'localhost';
    We can use grant previlages
     
    pstpl1, Dec 13, 2012 IP