31,029
edits
FAQ J'ai perdu mon mot de passe: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
mNo edit summary Tag: 2017 source edit |
mNo edit summary Tag: 2017 source edit |
||
| Line 29: | Line 29: | ||
C:\dolibarr\bin\mysql\mysql5.0.45\bin\mysql -u root | C:\dolibarr\bin\mysql\mysql5.0.45\bin\mysql -u root | ||
* A l'invite, tapez | * A l'invite, tapez | ||
< | <syntaxHighlight lang="sql"> | ||
mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'root'; | mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'root'; | ||
or on a more recent version | or on a more recent version | ||
mysql> SET PASSWORD FOR 'root@localhost' = PASSWORD('anewpassword'); | mysql> SET PASSWORD FOR 'root@localhost' = PASSWORD('anewpassword'); | ||
</ | </syntaxHighlight> | ||
Pour prendre en compte le changement | Pour prendre en compte le changement | ||
< | <syntaxHighlight lang="sql"> | ||
mysql> FLUSH PRIVILEGES; | mysql> FLUSH PRIVILEGES; | ||
mysql> QUIT; | mysql> QUIT; | ||
</ | </syntaxHighlight> | ||
* Tapez | * Tapez | ||
C:\dolibarr\bin\mysql\mysql5.0.45\bin\mysqladmin -u root -pmotdepasseroot shutdown | C:\dolibarr\bin\mysql\mysql5.0.45\bin\mysqladmin -u root -pmotdepasseroot shutdown | ||