set root password for mysql Posted on April 29, 2004 by Rick Hurst mysql> SET PASSWORD FOR root@rickhurst.co.uk=PASSWORD(‘new_password’);