31,029
edits
FAQ I Lost my password: Difference between revisions
Jump to navigation
Jump to search
m
→Change the user used by Dolibarr to connect to the database
Tag: 2017 source edit |
Tag: 2017 source edit |
||
| Line 83: | Line 83: | ||
<source lang="sql"> | <source lang="sql"> | ||
mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = ' | mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'userusedfordolibarrdatabase'; | ||
or on a more recent version | or on a more recent version | ||
mysql> SET PASSWORD FOR ' | mysql> SET PASSWORD FOR 'userusedfordolibarrdatabase@localhost' = PASSWORD('anewpassword'); | ||
</source> | </source> | ||
The to take the change into account. | The to take the change into account. | ||