Hi Brilliant. I already had an admin wp_capabilities row for the other username which I couldn’t log in with so copied that – it was slightly different from yours.
a:1:{s:13:”administrator”;s:1:”1″;}
It worked!
Thank you so much for taking the time to help.