Update MySQL root password - Ubuntu : <p>I want to update my MySQL password from <code>I9O*Kez</code> ---> <code>SO123*</code></p>

<p>I perform these </p>

<pre><code>mysql -u root -pI9O*Kez

service mysql stop 
mysqld_safe --skip-grant-tables &amp;
mysql -uroot

use mysql; 
delete from user where User='root';

CREATE USER 'root'@'%' IDENTIFIED BY 'SO123*';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'%';
</code></pre>

<p>I kept getting </p>

<pre><code>ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
</code></pre>

<p>Am I doing these completely wrong ? </p>

<p>It shouldn't be this difficult just to update a root password - right ?</p>
