FAQ I Lost my password: Difference between revisions

FAQ I Lost my password (view source)

196 bytes added , 1 year ago

m

31,029

edits

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