Help
Feel like a right idiot,
Had everything running well for a short time since installation and been very happy playing and tweaking outputs and dashboards, how ever i have some how managed to forget my password for login into EmonCMS, i changed username / password after setup.I have created a new user and can login with that but no access to all my settings,
I used the default images for Pi / HDD during setup,
How do i access the SQL to reset my user password?
Re: EmonCMS on Pi - Forgotten Password
I use the free phpmyadmin software to access the database where you should be able to reset your password. I think that the default mysql login is root/raspberry http://www.phpmyadmin.net/ Paul
Re: EmonCMS on Pi - Forgotten Password
You could use phpmyadmin, MySQL Workbench, the mysql commandline client or Sequel Pro if you're on a mac...
This way you could exchange the password and salt string from the new user with the one from your old one!
Edit: Uppsy had it in edit mode for too long... As an addition to what I already said: you need to have a line like this in your my.cnf: "bind-address = your-raspi-IP" I think usually it's only 127:::1
Re: EmonCMS on Pi - Forgotten Password
As Paul says phpmyadmin will do it, it's a useful tool to have anyway.
Since your using a Pi you can install using
sudo apt-get install phpmyadmin
you will need to enter your mySQL password and username,
Paul
Re: EmonCMS on Pi - Forgotten Password
Just tested it with my own setup, works as expected...
Re: EmonCMS on Pi - Forgotten Password
Wonderful
ssh into the pi install phpmyadmin failed, followed the tips to apt-get update then install phpmyadmin again and im in, password reset and logged back in,
I do like phpmyadmin and now its on the pi will get some use im sure.
Thanks
Re: EmonCMS on Pi - Forgotten Password
After a bit of fiddling managed to get phpmyadmin up and running (needed an update before it would install) password changed and im logged back in,
I do like phpmyadmin but wasn't sure if it would go on the pi image.
Thanks