Difference between revisions of "Setting the root password"

mysql> UPDATE mysql.USER SET Password=PASSWORD('MyNewPass')
    ->                   WHERE USER='root';
mysql> FLUSH PRIVILEGES;