UPDATE mysql.user
    SET password = PASSWORD('123'), Host = '%'
    WHERE User = 'root' AND Host = 'localhost';
FLUSH PRIVILEGES;

update user set password=PASSWORD("NEWPASSWORD") where User='nixcraft';