Cannot reset webui password

[taspence]

Hi All,
I took over IT at a facility that uses Fog. I have the SQL login username and password, but was never provided with a webui username and password. I tried the default username and password, and it did not work. I have version 0.29. I have booted to a recovery prompt, and done the following:

sudo mysql -u root -pMYPASSWORD fog

then it comes to a mysql prompt and I typed the following:

UPDATE users SET uPass = MD5(‘password’) WHERE uName = ‘fog’;

I get the following:

mysql> UPDATE users SET uPass = MD5(‘password’) WHERE uName = ‘fog’;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

I’m not sure what I’m doing wrong.

Thanks for any help in advance.

[chad-bisd]

look at the column names and the values for user. Make sure you are specifying the correct column name and value for uName.

If worse comes to worse, use something like phpmyadmin or NaviCat lite to edit the values using a GUI.