FAQ I Lost my password - Revision history

Eldy: /* If the lost password is that of the Dolibarr admin account */

2025-01-18T17:40:15Z

If the lost password is that of the Dolibarr admin account

← Older revision		Revision as of 17:40, 18 January 2025
Line 139:		Line 139:
	Log in to the Dolibarr mysql database and modify the "pass" field of the login with which you want to connect.		Log in to the Dolibarr mysql database and modify the "pass" field of the login with which you want to connect.
	<syntaxHighlight lang="sql">		<syntaxHighlight lang="sql">
	mysql> USE nomdelabaseolibar		mysql> USE nomdelabaseolibar;
	mysql> UPDATE llx_user SET pass = 'atemporarypasswod' WHERE login ='loginuserbloque';		mysql> UPDATE llx_user SET pass = 'atemporarypasswod' WHERE login ='loginuserbloque';
	</syntaxHighlight>		</syntaxHighlight>

	Try to connect then modify your password from your user profile. This will clear the unencrypted temporary password in order to store your new encrypted password in this table.		Try to connect then modify your password from your user profile. This will clear the unencrypted temporary password in order to store your new encrypted password in this table.

Eldy at 17:39, 18 January 2025

2025-01-18T17:39:37Z

← Older revision		Revision as of 17:39, 18 January 2025
Line 3:		Line 3:
	Links below will be automatically replicated on translated pages by PolyglotBot -->		Links below will be automatically replicated on translated pages by PolyglotBot -->
	[[fr:FAQ J'ai perdu mon mot de passe]]		[[fr:FAQ J'ai perdu mon mot de passe]]
	[[es:~~FAQ_Tengo_un_problema_en_la_contraseña_de_la_base_de_datos,_que_debo_hacer?~~]]		[[es:FAQ Tengo un problema en la contraseña]]
	<!-- END interlang links -->		<!-- END interlang links -->

Eldy at 17:38, 18 January 2025

2025-01-18T17:38:47Z

← Older revision		Revision as of 17:38, 18 January 2025
Line 2:		Line 2:
	<!-- You can edit this section but do NOT remove these comments		<!-- You can edit this section but do NOT remove these comments
	Links below will be automatically replicated on translated pages by PolyglotBot -->		Links below will be automatically replicated on translated pages by PolyglotBot -->
	[[fr:~~FAQ_J~~'~~ai_perdu_le_mot_de_passe_de_ma_base_de_données~~]]		[[fr:FAQ J'ai perdu mon mot de passe]]
	[[es:FAQ_Tengo_un_problema_en_la_contraseña_de_la_base_de_datos,_que_debo_hacer?]]		[[es:FAQ_Tengo_un_problema_en_la_contraseña_de_la_base_de_datos,_que_debo_hacer?]]
	<!-- END interlang links -->		<!-- END interlang links -->

Eldy: Eldy moved page FAQ I Lost my database password to FAQ I Lost my password

2025-01-18T17:36:43Z

Eldy moved page FAQ I Lost my database password to FAQ I Lost my password

← Older revision

Revision as of 17:36, 18 January 2025

Eldy at 17:36, 18 January 2025

2025-01-18T17:36:17Z

Show changes

Eldy: /* Linux */

2025-01-18T16:41:42Z

Linux

← Older revision		Revision as of 16:41, 18 January 2025
Line 142:		Line 142:

	$dolibarr_main_db_pass		$dolibarr_main_db_pass
	with value of the new password.
			with value of the new password. Note that the database user used to connect to the database is defined into $dolibarr_main_db_user.

	*Save file and quit. It should be ok.		*Save file and quit. It should be ok.
Line 164:		Line 165:
	mysql> QUIT;		mysql> QUIT;
	</syntaxHighlight>		</syntaxHighlight>

	*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}}

Eldy at 16:40, 18 January 2025

2025-01-18T16:40:04Z

← Older revision		Revision as of 16:40, 18 January 2025
Line 40:		Line 40:
	*At the MySQL prompt, type		*At the MySQL prompt, type

	<~~source~~ lang="sql">		<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');
	</~~source~~>		</syntaxHighlight>
	And to take change into account		And to take change into account
	<~~source~~ lang="sql">		<syntaxHighlight lang="sql">
	mysql> FLUSH PRIVILEGES;		mysql> FLUSH PRIVILEGES;
	mysql> QUIT;		mysql> QUIT;
	</~~source~~>		</syntaxHighlight>

	*Type		*Type
Line 82:		Line 82:
	*At the MySQL prompt, type		*At the MySQL prompt, type

	<~~source~~ lang="sql">		<syntaxHighlight lang="sql">
	mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'userusedfordolibarrdatabase';		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 'userusedfordolibarrdatabase@localhost' = PASSWORD('anewpassword');		mysql> SET PASSWORD FOR 'userusedfordolibarrdatabase@localhost' = PASSWORD('anewpassword');
	</~~source~~>		</syntaxHighlight>
	The to take the change into account.		The to take the change into account.
	<~~source~~ lang="sql">		<syntaxHighlight lang="sql">
	mysql> FLUSH PRIVILEGES;		mysql> FLUSH PRIVILEGES;
	mysql> QUIT;		mysql> QUIT;
	</~~source~~>		</syntaxHighlight>

	Note that you may need to change the "localhot" with the ip of the server if the database is onto another server.		Note that you may need to change the "localhot" with the ip of the server if the database is onto another server.
Line 114:		Line 114:
	*At the MySQL prompt, type		*At the MySQL prompt, type

	<~~source~~ lang="sql">		<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');
	</~~source~~>		</syntaxHighlight>
	Then validate the change with		Then validate the change with
	<~~source~~ lang="sql">		<syntaxHighlight lang="sql">
	mysql> FLUSH PRIVILEGES;		mysql> FLUSH PRIVILEGES;
	mysql> QUIT;		mysql> QUIT;
	</~~source~~>		</syntaxHighlight>

	*Type		*Type
Line 154:		Line 154:
	*At the MySQL prompt, type		*At the MySQL prompt, type

	<~~source~~ lang="sql">		<syntaxHighlight lang="sql">
	mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'dolibarruserofdatabase';		mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'dolibarruserofdatabase';
	or on a more recent version		or on a more recent version
	mysql> SET PASSWORD FOR 'dolibarruserofdatabase@localhost' = PASSWORD('passfordolibarruserofdatabase');		mysql> SET PASSWORD FOR 'dolibarruserofdatabase@localhost' = PASSWORD('passfordolibarruserofdatabase');
	</~~source~~>		</syntaxHighlight>
	And to take the change into account		And to take the change into account
	<~~source~~ lang="sql">		<syntaxHighlight lang="sql">
	mysql> FLUSH PRIVILEGES;		mysql> FLUSH PRIVILEGES;
	mysql> QUIT;		mysql> QUIT;
	</~~source~~>		</syntaxHighlight>

	*Go into		*Go into

Eldy: /* Change the user used by Dolibarr to connect to the database */

2025-01-18T16:39:12Z

Change the user used by Dolibarr to connect to the database

← Older revision		Revision as of 16:39, 18 January 2025
Line 155:		Line 155:

	<source lang="sql">		<source lang="sql">
	mysql> UPDATE mysql.user SET Password = PASSWORD('~~anothernewpassword~~') WHERE User = '~~userusedbydolibarr~~';		mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'dolibarruserofdatabase';
			or on a more recent version
			mysql> SET PASSWORD FOR 'dolibarruserofdatabase@localhost' = PASSWORD('passfordolibarruserofdatabase');
			</source>
			And to take the change into account
			<source lang="sql">
	mysql> FLUSH PRIVILEGES;		mysql> FLUSH PRIVILEGES;
	mysql> QUIT;		mysql> QUIT;

Eldy: /* Change the user used by Dolibarr to connect to the database */

2025-01-18T16:36:32Z

Change the user used by Dolibarr to connect to the database

← Older revision		Revision as of 16:36, 18 January 2025
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.

Eldy: /* With Microsoft Windows */

2025-01-18T16:34:09Z

With Microsoft Windows

← Older revision		Revision as of 16:34, 18 January 2025
Line 42:		Line 42:
	<source lang="sql">		<source 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
			mysql> SET PASSWORD FOR 'root@localhost' = PASSWORD('anewpassword');
			</source>
			And to take change into account
			<source lang="sql">
	mysql> FLUSH PRIVILEGES;		mysql> FLUSH PRIVILEGES;
	mysql> QUIT;		mysql> QUIT;
Line 65:		Line 70:
	$dolibarr_main_db_pass		$dolibarr_main_db_pass

	with value of the new password.		with value of the new password. The name of user is store into $dolibarr_main_db_user

	*Save file and quit. It should be ok.		*Save file and quit. It should be ok.

	~~If Dolibarr use another MySQL user than root,~~

	*Go in Windows menu		*Go in Windows menu
Line 80:		Line 83:

	<source lang="sql">		<source lang="sql">
	mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = '~~root~~';		mysql> UPDATE mysql.user SET Password = PASSWORD('anewpassword') WHERE User = 'userusedfordatabaseroot';
	or on a more recent version		or on a more recent version
	mysql> SET PASSWORD FOR '~~root~~@localhost' = PASSWORD('anewpassword');		mysql> SET PASSWORD FOR 'userusedfordatabase@localhost' = PASSWORD('anewpassword');
	</source>		</source>
	The to take the change into account.		The to take the change into account.
Line 90:		Line 93:
	</source>		</source>

	*Go into		Note that you may need to change the "localhot" with the ip of the server if the database is onto another server.

	~~C:\dolibarr\www\dolibarr\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~~.

	=Linux=		=Linux=