How to change webui passwords w/o using webui
-
[quote=“sam-white, post: 2993, member: 118”]Have you tried logging into MySQL using root and changing the password for the fog user?[/quote]
The link I have in my post is the method you are speaking of isn’t it? If not then no, I haven’t. -
“sudo” basically means run as root under this user. If you only used “sudo mysql” it should ask you for a root password. I would use the command “mysql -u root -p” to log into root and then try the link you posted.
-
This post is deleted! -
This post is deleted! -
I did as you said and received this in response:
mysql> UPDATE users SET uPass = MD5(‘password’) WHERE uName = ‘fog’;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0I tried logging in using fog as the uname and password as the passwd and nothing happens. It doesn’t log in or give me an error, just reloads the log in page basically. Is there no way to manually edit these files without going through the terminal or mysql?
-
This post is deleted! -
This post is deleted! -
This post is deleted! -
[FONT=Arial][COLOR=#111111]Try the below. I would also look at “/var/www/fog/commons/config.php” and “/opt/fog/service/etc/config.php” to make sure your mysql info is defined. Since fog uses MySQL, the user and passwords are stored there. You can also install “phpmyadmin” and see if your fog user is there. If you can log into root, you should be able to change the password and assign permissions to that user.[/COLOR][/FONT]
[LIST=1]
[][FONT=Arial][COLOR=#111111]mysql -u root -p[/COLOR][/FONT]
[][FONT=Arial][COLOR=#111111]mysql> use mysql;[/COLOR][/FONT]
[*][FONT=Arial][COLOR=#111111]mysql> update user set password=PASSWORD(“NEW-PASSWORD-HERE”) where User=‘fog’;[/COLOR][/FONT]
[/LIST] -
That did not work either, but the problem has been solved! Thank you very, extremely, much for helping me try to figure this thing out. It turns out somehow the only user we had in the database was [U]NOT[/U] the admin for some reason, my friendly neighborhood programmer found that issue and resolved it.
-
Glad you figured it out.
