FAQ I Lost my password: Difference between revisions

FAQ I Lost my password (view source)

144 bytes added , 1 year ago

m

31,029

edits

@@ Line 80: / Line 80: @@
 <source lang="sql">
-mysql> UPDATE mysql.user SET Password = PASSWORD('anothernewpassword') WHERE User = 'userusedbydolibarr';
+mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'root';
+or on a more recent version
+mysql> SET PASSWORD FOR 'root@localhost' = PASSWORD('anewpassword');
+</source>
+The to take the change into account.
+<source lang="sql">
 mysql> FLUSH PRIVILEGES;
 mysql> QUIT;