First of all this article intends to help all admins who are unable to login to WordPress control panel and aren't able to reset the password using the standard WordPress procedure, and so the only way is to add an admin user via database.
Sometimes you may need to add an admin user to a WordPress site via PHPMyAdmin; this short tutorial could help you accomplish this safely, using only a few queries.
Please note, I suggest you to backup your database as first step, so you could restore it if some problems arise.
Ok, do you save the backup in a safe place? Ok, let's go!
First of all log into your PHPMyAdmin interface, click on "SQL" label (on top right panel) and then copy and paste these lines: