This article is for those who have phpMyAdmin access to their SQL database. Please read: use phpMyAdmin at your own risk. If you are unsure of your ability to carry-out the task below, seek further advice from a professional. We are not responsible for ANY loss of data.

1) Log-in to phpMyAdmin and click databases.

a) A list of databases will appear. Click your WordPress database.
b) All the tables in your database will appear. If not, click ‘Structure’.
c) Look for wp_users (or whatever prefix you have set).
d) Click on the icon for browse or structure. Read more