MySQL Change a User Password - nixCraft: Linux Tips, Hacks, Tutorials, And Ideas In Blog Form

Small modification in 3rd step… according to the mysql documentation, the password should be typed within single quotes instead of double quotes. But double quotes works. Refer the example below… mysql> UPDATE user SET Password=PASSWORD(‘NEW ...

www.cyberciti.biz