Reset WebUI FOG password - Revision history

Wayne-workman.28155 at 16:08, 23 November 2018

2018-11-23T16:08:05Z

Berend-de-boer.28367: /* Reset password */ don't supply password on command-line, will be stored in history, mysql will prompt

2015-03-17T03:58:02Z

‎Reset password: don't supply password on command-line, will be stored in history, mysql will prompt

Chad-bisd: tidied up the article a bit

2012-08-01T02:38:30Z

tidied up the article a bit

New page

== Overview ==
If somehow you lose access to the FOG server web interface, you can use the following procedure to connect to the MySQL database and reset the password for any existing FOG user. These user accounts and passwords are only for logging into the FOG server web interface and should not be confused with other fog users in the operating system.

== Reset password ==

On the FOG server where the MySQL "fog" database is installed, execute the commands:

*If the root user in MySQL does not have a password:
<pre>
sudo mysql -u root fog
</pre>

*If the root user in MySQL does have a password:
<pre>
sudo mysql -u root -pROOTUSERPASSWORD fog
</pre>

*Run this query to reset the password. You can change users other than "fog" by changing the uName value in the query.
<pre>
UPDATE users SET uPass = MD5('password') WHERE uName = 'fog';
exit;
</pre>

Login to the WebUI with:
*Username: fog
*Password: password (or whatever you used in the query above inside the MD5 call)

← Older revision		Revision as of 16:08, 23 November 2018
Line 1:		Line 1:
		+	This is an older article. See the new one here: [[Password Central]]
		+
	== Overview ==		== Overview ==
	If somehow you lose access to the FOG server web interface, you can use the following procedure to connect to the MySQL database and reset the password for any existing FOG user. These user accounts and passwords are only for logging into the FOG server web interface and should not be confused with other fog users in the operating system.		If somehow you lose access to the FOG server web interface, you can use the following procedure to connect to the MySQL database and reset the password for any existing FOG user. These user accounts and passwords are only for logging into the FOG server web interface and should not be confused with other fog users in the operating system.

@@ Line 6: / Line 6: @@
 On the FOG server where the MySQL "fog" database is installed, execute the commands:
-*If the root user in MySQL does not have a password:
+*If the root user in MySQL does ''not'' have a password (or it's stored in <tt>~/.my.cnf</tt>):
 <pre>
 sudo mysql -u root fog
 </pre>
-*If the root user in MySQL does have a password:
+*If the root user in MySQL does ''have'' a password:
 <pre>
-sudo mysql -u root -pROOTUSERPASSWORD fog
+sudo mysql -u root -p fog
 </pre>