Change root password

Change root password in MySQL by command prompt

$ mysql -u root -p’current_password’

$ UPDATE user SET password=PASSWORD(‘newpassword’) WHERE user=’root’;