How to disable SET PASSWORD for users?

Discussion in 'MySQL' started by Multiplexor, Feb 3, 2011.

  1. #1
    How to forbid the user changing his password?

    According to the official doc, SET PASSWORD works only for users having UPDATE priviledge on the mysql.user-Table:
    http://dev.mysql.com/doc/refman/5.1/de/set-password.html

    However, any newly created user with no privileges at all can change his password with
    SET PASSWORD = PASSWORD('verysecret');
    PHP:

    How can I deny users changing their passwords?
     
    Multiplexor, Feb 3, 2011 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    mwasif, Feb 3, 2011 IP
  3. Multiplexor

    Multiplexor Greenhorn

    Messages:
    57
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #3
    Do I understand this right: There is no way to prevent users from changing their own password in MySQL?
     
    Multiplexor, Feb 4, 2011 IP
  4. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #4
    Yes, AFAIK.
     
    mwasif, Feb 4, 2011 IP