SET PASSWORD

    SET PASSWORD [FOR user_identity] = [PASSWORD(‘plain password’)]|[‘hashed password’]

    Note that the user_identity here must match exactly the user_identity specified when creating a user using CREATE USER, otherwise the user will be reported as non-existent. If user_identity is not specified, the current user is ‘username’@’ip’, which may not match any user_identity. The current user can be viewed through SHOW GRANTS.

    SET PASSWORD = PASSWORD(‘123456’) SET PASSWORD = ‘*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9’

    1. Modify the specified user password

    SET, PASSWORD