SET PASSWORD statement

This statement is used to change the user's password.

Syntax

SET PASSWORD new_password old_password 
Keyword Description
new_password New password
old_password Old password

Use

This statement is used to change the user's password.

Example

SET PASSWORD  newpass oldpass
SET PASSWORD mynewpass ''42pass''