So, our previous admin was abusing his role, kicked our webdevs from accessing the site etc. so we kicked him from the guild and took the site back.
I now have the database and site on my local linux server.
I finally managed to get the database connection sorted out, but I have no admin account on it. I can't log in on the site as it is in maintenance mode.
how do I set myself as administrator on the site through the database? once logged in, can I grant administrator rights to others in the website?