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

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mnt/104/sda/7/8/domitib/myNotes/fonctions.php on line 65