Zmiana hasła roota bazy mysql

SET PASSWORD FOR root = PASSWORD('mypass');

UPDATE user SET Password = PASSWORD('pass') WHERE user = 'root';