MySQL secure

Discussion in 'MySQL' started by puya4ever, Aug 14, 2010.

0
  1. #1
    Hi to everyone. How can I set a restriction that I can connect to root account only from localhost on the mysql server ?

    I use debian as OS.

    Thanks.
     
    puya4ever, Aug 14, 2010 IP
  2. netload

    netload Member

    Messages:
    105
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    28
    #2
    Add
    in my.cnf
     
    netload, Aug 15, 2010 IP
  3. longvnit

    longvnit Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    U can insert this line into my.cnf
    bind-address=127.0.0.1
    Code (markup):
     
    longvnit, Aug 18, 2010 IP
  4. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #4
    Update root user privileges to login only from localhost.
     
    mwasif, Aug 19, 2010 IP