What does
$ mysql -uroot -p
USE emoncms;
SELECT * FROM users;
exit
give you?
[edit]
@TrystanLea @pb66 I note that this installation appears to be older and as it has a mysql prompt - has anything changed to get the right username?
I tried the instructions but cannot get the right password for root on an EmonPi.
pi@emonpi:~ $ mysql -uroot -p
Enter password:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
[edit2]
Instructions should be (for new installs)
$ mysql -uemoncms -p
USE emoncms;
SELECT * FROM users;
exit
and the emoncms user password in settings.php.