====== Changer le mot de passe root MySQL ======

----

**  1. Stop mysql:**
<code bash>systemctl stop mysqld</code>

**  2. Set the mySQL environment option** 
<code bash>systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"</code>

**  3. Start mysql usig the options you just set**
<code bash>systemctl start mysqld</code>

**  4. Login as root**
<code bash>mysql -u root</code>

**  5. Update the root user password with these mysql commands**
<code bash>mysql> UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPassword')
    -> WHERE User = 'root' AND Host = 'localhost';
mysql> FLUSH PRIVILEGES;
mysql> quit</code>

**  6. Stop mysql**
<code bash>systemctl stop mysqld</code>

**  7. Unset the mySQL envitroment option so it starts normally next time**
<code bash>systemctl unset-environment MYSQLD_OPTS</code>

**  8. Start mysql normally:**
<code bash>systemctl start mysqld</code>

**  9. Try to login using your new password:**
<code bash>mysql -u root -p</code>