[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: recréer le compte root mysql



> 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

https://dev.mysql.com/doc/refman/5.7/en/set-password.html

Enjoy,

Ph. Gras


Reply to: