Re: recréer le compte root mysql

Sat, 01 Apr 2017 02:49:41 -0700 

> 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

Répondre à