31,029
edits
FAQ I Lost my password: Difference between revisions
m
→Linux
m (→Linux) |
|||
| Line 61: | Line 61: | ||
= Linux = | = Linux = | ||
== Reset the root password of Mysql == | |||
* Connect to a terminal console with user roor. | |||
* Stop Mysql: | |||
/usr/sbin/mysql stop | |||
* Type the following line to restart MySQL in a particular mode. | |||
/usr/sbin --skip-grant-tables | |||
* Launch another terminal console. | |||
* Type in this new windows | |||
/usr/bin/mysql -u root | |||
* At the MySQL prompt, type | |||
<source lang="sql"> | |||
mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'root'; | |||
mysql> FLUSH PRIVILEGES; | |||
mysql> QUIT; | |||
</source> | |||
* Type | |||
/usr/bin/mysqladmin -u root -panewpassword shutdown | |||
* Restart your server or only mysql server. | |||
You should now be able to access your MySQL database, you can now tell to Dolibarr to use the new password. | |||
== Change Dolibarr config file to use new password == | |||
If you use the root user also to allow Dolibarr to connect to your database (not recommanded but why not) | |||
* Go into | |||
htdocs\conf | |||
* Edit file conf.php to change variable | |||
$dolibarr_main_db_pass | |||
with value of the new password. | |||
* Save file and quit. It should be ok. | |||
If Dolibarr use another MySQL user than root, | |||
* Ru mysql with root user | |||
/usr/bin/mysql -u root -ppassword | |||
* At the MySQL prompt, type | |||
<source lang="sql"> | |||
mysql> UPDATE mysql.user SET Password = PASSWORD('anothernewpassword') WHERE User = 'userusedbydolibarr'; | |||
mysql> FLUSH PRIVILEGES; | |||
mysql> QUIT; | |||
</source> | |||
* Go into | |||
htdocs\conf | |||
* edit file conf.php and search lines | |||
$dolibarr_main_db_user="xxx"; | |||
$dolibarr_main_db_pass="yyy"; | |||
Replace xxx and yyy by real values. | |||
= Mac = | = Mac = | ||
== DoliMamp == | == DoliMamp == | ||
{{ToComplete}} | {{ToComplete}} | ||