mysql

Способ 1:
mysqladmin -u root password new_password
Способ 2:
mysql -u root mysql
Способ 3:
mysql>

SET PASSWORD FOR root@localhost=PASSWORD('new_password');