Lost admin privileges to wordpress

Hi,

Please i have this exact problem as found in a v3 thread,

i think i removed administrator from admin groups without full understanding, i do now as ive lost all admin privileges to my wp account

please assist as this is a production server and my backup is a day or two old,

i have tried resetting the admin password
creating a new admin user with phpmyadmin and creating it to administrator by using wp_usermeta to apply administrator

I do now know how to do the add product then relay new admin privileges that way, a response is urgently appreciated

thank you so much

this is for amember v4

guys im a knacker and learn as i go along

but

SELECT*
FROMwp_usermeta
WHEREuser_id=1
ANDmeta_key='wp_capabilities'
LIMIT0,30

do this, then use the line

a:1:{s:13:"administrator";b:1;}

and were in

i'm just going to go wipe my soil and have chocolate reward after a backup ofcourse