Re: lost my status as site admin. how to restore?
You can create another user and make them a site admin in: Site Admin > Options > Administration Settings (Site Admins)
That lists all the users who are desginated ‘site admins’. This might help: https://wordpress.org/support/topic/184012
Perhaps your earlier trial at this didn’t work because your new username wasn’t on the list? If you are going to do the db route again add the new username first. 
