方法1: 用SET PASSWORD命令

  mysql -u root

  mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');

 

http://jingyan.baidu.com/article/0320e2c198ad5f1b87507bc8.html