First of all, I’d like to say Hello to everyone who is reading this topic.
I recently purchased the EmonPi after spending a good few months trying to find an energy monitor that would fit. I’ve managed to get it all set up and running giving me the real-time information I was looking for.
However, I was wanting to manually change the pulse sensor value to match what i have on my consumer unit. I’m lucky that I have 1k pulses per 1kw so there isn’t much math involved to get this to function using the pulse sensor that I purchased.
Here is what I have tried:
Logging into MySql using HeidiSQL ( Remote sql connection over the Lan )
I added in a rule sudo ufw allow MySQL and checked netstat to see if the device was listening,
Then I tried to log in but the account does not have a remote connection enabled…
MYSQL, I logged into here via SSH using the credentials provided in Service Credentials - Guide | OpenEnergyMonitor
but the account does not have permission to add remote connectivity.
The reason I’m trying to use HeidiSQL is due to the lack of SQL knowledge and I’m more comfortable using the GUI that it comes with.
I did have a quick search on the form to see if anyone else has had an issue connecting to the local MariaDB server but i didn’t find anything that stood out.
Thanks in advance.