31,029
edits
FAQ J'ai perdu mon mot de passe: Difference between revisions
Jump to navigation
Jump to search
m
→Sous Microsoft Windows
m (→Linux) Tag: 2017 source edit |
Tag: 2017 source edit |
||
| Line 28: | Line 28: | ||
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 | ||
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> | |||
Pour prendre en compte le changement | |||
<source lang="sql"> | <source lang="sql"> | ||
mysql> FLUSH PRIVILEGES; | mysql> FLUSH PRIVILEGES; | ||
mysql> QUIT; | mysql> QUIT; | ||
| Line 57: | Line 61: | ||
<source lang="sql"> | <source lang="sql"> | ||
mysql> UPDATE mysql.user SET Password = PASSWORD('nouveau_mot') WHERE User = 'lenomducompte'; | mysql> UPDATE mysql.user SET Password = PASSWORD('nouveau_mot') WHERE User = 'lenomducompte'; | ||
or on a more recent version | |||
mysql> SET PASSWORD FOR 'lenomducompte@localhost' = PASSWORD('anewpassword'); | |||
mysql> SET PASSWORD FOR 'lenomducompte@%' = PASSWORD('anewpassword'); | |||
</source> | |||
Pour prendre en compte | |||
<source lang="sql"> | |||
mysql> FLUSH PRIVILEGES; | mysql> FLUSH PRIVILEGES; | ||
mysql> QUIT; | mysql> QUIT; | ||