28,870
edits
Changes
m
→Change the user used by Dolibarr to connect to the database
Line 83:
Line 83:
<source lang="sql">
<source lang="sql">
−mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'userusedfordatabaseroot';
+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 'userusedfordatabase@localhost' = PASSWORD('anewpassword');
+mysql> SET PASSWORD FOR 'userusedfordolibarrdatabase@localhost' = PASSWORD('anewpassword');
</source>
</source>
The to take the change into account.
The to take the change into account.