I recently had a situation where the admin account on a WordPress installed site got removed or merged into another user account. Obviously WordPress doesn’t allow you to create new admin accounts outside the CMS so I was stuck and locked out from doing anything. Thankfully after much searching I found this great blog post which gave a clear step-by-step instructions on how to resolve the issue using phpMyAdmin. Thankfully the issue was resolved in less than 5 minutes and with no hassle. Well worth bookmarking the article as you may need it one day.
