When I try to add a new user in WordPress under Admin > Users > Add New User, it shows blank dropdown.
I manually tried to change the WordPress prefix after WordPress blog was created. I made change only within wp-config.php and renamed tables but it required change in data as well. This caused the issue.
Table PREFIX_options has a record with option_name = ‘wp_user_roles’. Change the option_name to ‘PREFIX_user_roles’.
Table PREFIX_usermeta has a record with meta_key = ‘wp_capabilities’ and ‘wp_user_level’. Change meta_key to ‘PREFIX_capabilities’ and ‘PREFIX_user_level’.