To run my project (node-red) decently I have reached a conclusion where I’d like to use MySQL instead of arrays in code (longer story).
I’d like to use MySQL that is already in emonPi but
I cant add my own databases/tables etc as MySQL root access is disabled and emoncms does not have sufficient privileges (understandably).
So, 2 questions:
- how can I create additional users with privilege levels that enable creation of new DB’s. Basically how can I access root level?
- what else should I be cautious about (data amounts of course, write as little and as rare as possible of course)?