recréer le compte root mysql

[bernard.schoenacker@free.fr]

bonjour,

je recherche la syntaxe pour recréer le compte root (admin) MySQL en ligne de commande

update user set password=PASSWORD(" ") where User='root';ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'update user set password=PASSWORD(" ") where User='root'' at line 2


merci d'avance

slt
bernard