Elevate an existing user to admin with mysql statements?

Hello friends,

unfortunately I screwed up my nextcloud admin account on the database level, and long story short, I’m left with no admin account on my nextcloud instance at all.

Is there a way to elevate my existing user “vincent” to administrator using sql statements? (no occ, since I don’t have ssh access right now, only mysql access)

Best regards,

Probably something like this:

insert into <DB Name>.oc_group_user (gid,uid) values ("admin","vincent")

1 Like