Reset du password mysql (sans le password root)

# Ces quelques étapes concernent mySQL sur un serveur Ubuntu/Debian 

# Arrêt de mySQL 

sudo /etc/init.d/mysql stop

# Démarrage

sudo mysqld_safe -skip-grant-tables &

sudo mysql -u root

mysql> use mysql;

mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';

mysql> flush privileges;

mysql> quit

sudo /etc/init.d/mysql restart