Merubah all password mysql root

> SET old_passwords =0; 
UPDATE mysql.user SET PASSWORD = PASSWORD( '_pass_' ) WHERE User = '_user_' LIMIT 1 ; 
SELECT LENGTH( 
PASSWORD ) 
FROM mysql.user 
WHERE User = '_user_'; 
FLUSH PRIVILEGES ;