I should put my two-cents in here to help others in this situation as I have done the above suggested (changing the ‘wp_user_roles’ data to the above, as well as a custom one [since I have also created different user roles via ‘User Role Editor’ plugin]), and it worked, BUT rather than delving into the database and possibly doing something wrong (especially if an individual is uncomfortable accessing the database), this can all be handled via front-end:
SCENARIO: If you happen to have either default S2Member user roles (S2Member levels 1-4) AND/OR custom ones you’ve made (via utilizing ‘wp-config.php’ to add new roles [ http://www.s2member.com/faqs/#s2-faqs-level-extensions ]), and you realize that you don’t want to use certain roles AND/OR eliminate them all-together, you need to install the WordPress plugin ‘User Role Editor‘.
Once installed, access it via your admin panel under ‘USERS: USER ROLE EDITOR’. Once here, you will see a ‘Role Chart’ and a list of roles you can check/uncheck for certain users. Avoid this for now, and scroll down until you see the tab named ‘Delete Role’ – Once here, click the down arrow to view all the roles currently associated to your website (example: editor, s2Member Level01, etc.), and one-by-one you can delete each role you don’t want anymore. Keep doing this until you’ve deleted all the user-types you don’t want anymore. Easy as that.
NOTE: If you DID add more levels via the ‘wp-config.php’ method pointed out above, you will definitely want to ensure you edit that file to reflect your intention (example: if you want to remove ALL S2member levels, then just delete the code within wp-config.php define(“MEMBERSHIP_LEVELS”, 4); – OR – if you just want to remove certain ones, BUT are keeping some custom ones, you will want to change the define(“MEMBERSHIP_LEVELS”, 4); from ‘4’ [or whatever number] to your new proposed number).
The method mentioned previous to mine works just fine, but if you’re uncomfortable tinkering in database files and are looking for a solid ‘front-end’ solution, then use ‘User Role Editor’ and you will be a happy person :)
Hope this helps out others who are finding it difficult to delete/edit user roles they don’t need anymore :)
Roger Sanchez