[5.7 이전 버젼]

update mysql.user set password=password('123456') where user='root';

FLUSH PRIVILEGES;

[5.7 이후 버젼]

update user set authentication_string=password('123456') where user='root';

FLUSH PRIVILEGES;