Change User ID after recreating account

[peteclyde (Pete Martin)]

So in playing around and setting up Emoncms on my own Ubuntu server, I loaded some sample data and ended up deciding to delete the one and only user and starting again.

So I recreated my user from the login screen and have just realised that I have no admin access. A forum search shows that the admin user must be user 1, however by deleting a user and starting from scratch, the system allocated me User ID 2 - hence no Admin access. And because I deleted User ID 1, I have no way of logging in that way.

So, short of starting from scratch with a new install (I really really don’t wanna do that) - is there any other way?

I’m thinking of access mysql via the command line and changing the User ID to 1 - will that break anything ? Or is there an ‘admin’ tag inside the mysql datase as well?

Any help appreciated .

Pete M

[Robert.Wall]

This has happened before. Did you try searching here?

Weird case user 1 got corrupted somehow

Something similar was reported (and solved) fairly recently, but I simply cannot find the the thread. From what I remember, it involves setting a flag to allow the local emonCMS to become multi-user, create a second user, then copy part of the (valid and working) database of the new user over the bad data for the original.

Login into Emonpi

They are held in an encrypted form in the mysql tables, I do not think you can (easily) unencrypt the password from the mysql data. In settings.php you should be able to enable the “reset password” feature (off by default) which will allow you to reset your password via a link that then becomes visible at the log in screen. However this requires the email settings to also be configured correctly in settings.php and swift mail to be installed and working. What will be easier is to enable the “…

Note - this relates to an old version of emonCMS - locations and names (i.e. settings.php) have changed, but I’m not familiar with the details.

[peteclyde (Pete Martin)]

Hi Robert,

Yes I’d done a search prior to posting. Those thread you linked don’t help out my particular issue.

Update: Problem solved.

I backed up the mysql database from using MYSQL at the command line, then updated UserID 2 from Admin = 0 to Admin =1

(UPDATE users SET admin=1 WHERE id=2;)

Logged out, logged back in. Admin functions are back.

Pete